Open form at last entry

[Guest]

If I have a form linked directly to a table, how can I set the form up so
that when it opens the last entry is showing and not the first?

 

[Guest]

Assumig that you have a field that point to the last record, like counter, or
date insert.
Make the recordsource of the form with order in that field
Select * From MyTable Order By MyField

 

[Joseph Meehan]

If I have a form linked directly to a table, how can I set the form
up so that when it opens the last entry is showing and not the first?

Just for the record. Tables do not have an order. It is more of bucket
of data. If you want to identify the "last" record, you need to add some
sort of method to do so. Date or incrementing number fields should work.
Autonumbers will not work as they can not be relied on to maintain order,
only to provide a unique number.