Open form to last record

[sByrne]

Hello,

This is probably an easy question. I have a form which when it opens, it opens to the first record. I want it to open to the last record. Any ideas on how to do this?

Many thanks!

 

[maxmangion]

Docmd.GoToRecord , , acLast

 

[mdemarte]

Sometimes you can also set the default sort order as descending , if the form allows that. Works great for a form where the primary key is an autonumber field.