Open Up to Last Record

[Guest]

I have a continuous form – When it opens, it opens up displaying the first
record.
I would like it to open up showing the last record including the empty
record for the new record.
Can this be done?

 

[Guest]

Try assigning an autonumber ID field and have the form sort by ID descending.

 

[Guest]

Try assigning an autonumber ID field and have the form sort by ID descending.

Do what Chris said first. (If the table doesn't already have a primary key then
set this autoincrement number field as the primary key and you won't have to do
the sort, it will be done automatically)

Next do one of the following depending on what you are really asking.

1. If you are asking to go to the last record already entered, the add a macro to
the form open event Goto Record - Last.

2. If you are asking to goto the empty record at the end of a table, which is
really the place a new record goes, then instead add a macro to the form open
event Goto Record - New.

gm