Go to the last record automatically

A

Aurora

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
 
S

Steve Schapel

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

Need Help with Macro Security 1
Turning off automatic calculation 0
MS365 WORD: How to Create Macro Button to CLEAR ALL fields in fill-in form 1
How do I clear a form? 0
Adding data to MS Access from csv file 0
Sub projects added as read only in Master file which are saved on sharepoint 1
Clearing Fields in a Word Form 5
Copy previous record into form field 0

Top