form opening to most recent record

  • Thread starter Thread starter tag
  • Start date Start date
T

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.
 
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.
 
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.
 
Back
Top