Go to the last record automatically

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using Access 2000.
I have a macro that open a form for editing. I want the macro to open the
form with the last record entered. I think I need a filter, in the open form
macro, for this, but do not know how to create it. Can anyone help me or
point me in the right direction please?

Aurora
 
Aurora,

On what basis do you know if a record is the "last record entered"? Do
you have an incremental ID or AutoNumber field in the table, for
example, or do you have a Date/Time field in the table which records
when the record was created?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Automatically Send a notification email once a record is added 0
going to last record in subform 1
Returning to Record after running Macro 2
Use Macro to Filter records in Subform on open 0
Excel Macro to automatically go to the right of the last colored cell 0
Access Command to run access, open to specific form and specific record 1
GoTo Last record ? 1
Access 2003 Access Error Form Name 0

Back
Top