I am using:
DoCmd.GoToRecord , , acNext
To scroll through my records.
My problem is that when I click next on the last record it opens a new record which I don't want.
I want to display a message saying "You have reached the last record".
How do I determine if I have reached the last record?
DoCmd.GoToRecord , , acNext
To scroll through my records.
My problem is that when I click next on the last record it opens a new record which I don't want.
I want to display a message saying "You have reached the last record".
How do I determine if I have reached the last record?