How to have a Form open to Last Record

[djclntn]

The Code in which I often use (& works) to have a Form open up to a New Record is:

Private Sub Form_Load()
DoCmd.GoToRecord , , acNewRec
End Sub

However, in one of my Forms I wish to have it open up to the Last Record, so in my above code I thought to replace 'New' with 'Last' but it's not working.

Private Sub Form_Load()
DoCmd.GoToRecord , , acLastRec
End Sub

[June7]

Try acLast.

As you type the code, are you seeing intellisense popup tips?

[djclntn]

Damn, now I can't remember what Form I was working with. Thanks June, I'm going to mark this thread as solved. If I remember which Form & have a problem I'll PM you.

[June7]

If you left the code in place a Debug>Compile should hit on the bad line. Or do a Find search of the VBA code for the acLastRec string.

[Tracyd]

hi - I'm trying to do the same, but not working ! any suggestions? - I want to display the last record on form load?

[Bob Fitz]

Try:
DoCmd.GoToRecord , , acLast
instead of:
DoCmd.GoToRecord , , acLastRec