Start at

[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.

 

[fredg]

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).