Return to place in table

[Guest]

In MS Access 2002, when I exit a record and go back to the main table, it
returns me to the beginning of the table, rather than returning me to my spot
in the list, which gets annoying since there are over 1000 records in the
table. Is there a way to set it so that I can return to my original place in
the table (where I was when I opened the record)?

 

[Allen Browne]

You can't do that in a table, but you can in a form.
You can make the form in Datasheet view so it looks like the table if you
wish.

To achieve what you want, the code must save the primary key value when you
close the form, and then find that record again when the form is next
loaded. Details in:
Return to the same record next time form is opened
at:
http://allenbrowne.com/ser-18.html

 

[Larry Linson]

In MS Access 2002, when I exit a record
and go back to the main table, it returns me
to the beginning of the table, rather than
returning me to my spot in the list, which
gets annoying since there are over 1000
records in the table. Is there a way to set it
so that I can return to my original place in
the table (where I was when I opened the record)?

Are you in a continuous forms view Form before you "open the record"? If so,
save the unique key of the current record and use it to find that record
again. Better yet, leave the original "selection" form open behind your
detail Form, and when you go back, the cursor will still be on the same
record from which you selected.

In a sample database, the VBA code (in the DoubleClick event) I use to open
a detail Form from a Form listing the employees (from the example
Northwind.MDB) is:

DoCmd.OpenForm "Employees", , , "[EmployeeID] = " & Me.txtEmployeeID

And, when I return to the (never closed) employee list form, it is still on
the same record.

Larry Linson
Microsoft Access MVP