form opening to most recent record

[tag]

My table has an autonumber field. When I open my form I
want the most recent (highest) autonumber data to pop up
on my screen.

Currently, the first record in the table pops up as
opposed to the last. How can I change that?

thanks in advance for any tips.

 

[Cheryl Fischer]

You could make the record source of your form a query and, in that query,
you can sort the records by your Autonumber field in Descending order.

 

[Rick B]

In the forms OnOpen event...

Private Sub Form_Open(Cancel As Integer)
DoCmd.GoToRecord , , acLast
End Sub





Rick B



My table has an autonumber field. When I open my form I
want the most recent (highest) autonumber data to pop up
on my screen.

Currently, the first record in the table pops up as
opposed to the last. How can I change that?

thanks in advance for any tips.