Forum Discussion
Solved
DoCmd.GoToRecord , , acLast
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
You could try
Private Sub Form_Load()
DoCmd.GoToRecord , , acLast
Docmd.GoToRecord ,, acPrevious
End Sub
You could try
Private Sub Form_Load()
DoCmd.GoToRecord , , acLast
Docmd.GoToRecord ,, acPrevious
End Sub- ahh... perfect. thank you!
