last record in datasheet

[seeker]

I have a form that opens in datasheet in asc order. My client would like for
the form to open at the last record so that he can arrow up if he chooses to
do so. How does a form open to the last record available. Thanks.

 

[John W. Vinson]

I have a form that opens in datasheet in asc order. My client would like for
the form to open at the last record so that he can arrow up if he chooses to
do so. How does a form open to the last record available. Thanks.

Put code in its Load event:

Private Sub Form_Load()
DoCmd.GoToRecord acForm, Me.Name, acLast
End Sub