last record in datasheet

  • Thread starter Thread starter seeker
  • Start date Start date
S

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.
 
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.
Click to expand...

Put code in its Load event:

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