Go to the last record automatically

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Aurora - 19 Dec 2005 21:23 GMT

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

Reply to this Message

Steve Schapel - 20 Dec 2005 17:13 GMT

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?

Signature

Steve Schapel, Microsoft Access MVP

> I am using Access 2000.
> I have a macro that open a form for editing. I want the macro to open the
[quoted text clipped - 3 lines]
>
> Aurora

Reply to this Message