Form Opening to Last Record

[jodilees]

How do I get a form to open to the last record. In the properties of the icon I have tried using the expression builder, but I can't seem to get it to work, it seems to add an expression but then the expression does not work and when I try to use the button I get an error message.

Any ideas??

Regards

Jodi

 

[pdx_man]

in the form's code:

Private Sub Form_Load()

     DoCmd.GoToRecord acDataForm, , acLast

End Sub