Default to last record on a Form ?? Please Help?

M

Manny

Hi All

I am trying to show the last record when a form opens in edit mode. This
form has numrous records and it defaults to the first record only.

Can this be done?

Appreciate your help!.
 
A

Allen Browne

In the Load event procedure of the form:

If not Me.NewRecord Then
RunCommand acCmdRecordsGoToLast
End If
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

default in new record 1
last recordset 4
How to Partially Populate New Record 1
Cant edit Access 2003 form 3
Open a form on click to edit data from a Multiple Item Form 2
Access Main form/Subform Navigation 0
HELP! Please!!! Click data and open a form to edit that same data. 3
Pop-up form that creates record that links 1:1 to main form 0

Top