RE: Edit Current Record Only

Just a little bit of instruction here because of this that you wrote:

"I am using the acLast command to jump to the last record on each form."

You probably didn't realize this, but unless you use a query to set a sort
order, Access does not necessarily display the records in any particular
order. If you have a primary key field, the initial view should be sorted by
that primary key, but the order can change. So, you'd better make sure that
acLast will ALWAYS take you to the last record. I would highly suggest using
queries instead of the table within your forms.

It is easy to transition.

1. Open your form in design view.

2. Go find the Record Source in the properties.

3. Click on the elipsis (...) that appears when you put your mouse over the
area next to the table name in the Record Source Property.

4. It will ask you if you wish to create a query based on the table.

5. Say YES.

6. Drag and drop the fields into the grid.

7. set the sort order for the field in the query that you want to use to
make sure that the order is the way you want it.
--
Bob Larson
Access World Forums Super Moderator
Utter Access VIP
____________________________________
Access 2000, 2003, 2007, SQL Server 2000, Crystal Reports 10/XI, VB6
WinXP, Vista


"Tim" wrote:

Hello,
I have a DB that contains 18 forms. The user populates one form at a time
and clicks a continue button at the bottom to move to the next form. I have
a query running when they click the next button that pulls the Branch # and
Date and populates the next Form. All that seems to works fine, except that
it gives the user the option to add and edit other records beside the one
they are adding. With the way the mouse wheel scrolls through records, I can
see the wrong records being edited.

I tried setting the Data Entry to YES, but this bypasses the last record
that has the Branch # and Date from the query that ran and only shows a blank
form. I am using the acLast command to jump to the last record on each form.

Is there a way to go to the last record and lock out all pervious records
and the option to add records?

Thanks.

.