DoCmd.GoToRecord , , acLast

[Tony2021]

Hello, how can I go modify the below to go to the next to last record?  For example, if the last record was 10, I would want to go to 9.  I put a -1 at the end but that didnt work. 

Private Sub Form_Load()

       DoCmd.GoToRecord , , acLast
End Sub

thank you

[#2 · Accepted solution]

@Tony2021 

You could try

Private Sub Form_Load()

       DoCmd.GoToRecord , , acLast

       Docmd.GoToRecord ,, acPrevious
End Sub

[#3]

ahh... perfect. thank you!