Start at

  • Thread starter Thread starter rob p
  • Start date Start date
R

rob p

I have a table using auto number. Increment by 1 starting at 1. In my form
for that table, is there a way for it to display the highest number upon
open rather than the lowest (1)?
thanks.
 
I have a table using auto number. Increment by 1 starting at 1. In my form
for that table, is there a way for it to display the highest number upon
open rather than the lowest (1)?
thanks.

In the Form's Load event:
DoCmd.RunCommand acCmdRecordsGoToLast

Will go to the last record (which will be dependent upon your sort
order).
 
Back
Top