Open DB on LAST record, not FIRST

  • Thread starter Thread starter RitchieJHicks
  • Start date Start date
R

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