Open DB on LAST record, not FIRST

[RitchieJHicks]

Hi,

Currently when I enter one of my data entry forms, it always opens on the
first record in the table, that being 1 (set by primary key).

Is there anyway that I can set the form to open on the LAST inputted record,
instead of the first?

 

[Douglas J. Steele]

What does "last" mean to you? Recognize that in a table, there is no order:
tables are unordered sacks of data, where Access puts the rows wherever they
fit best.

If you can define what "last" means, create a query that has an appropriate
ORDER BY clause, and use that query as the form's RecordSource rather than
the table.

 

[B. Edwards]

Private Sub Form_Load()

DoCmd.GoToRecord Record := acLast

End Sub

 

[RitchieJHicks]

Thanks "B.Edwards". That did the trick just lovely!