if I replace the Access record navigator through my own buttons how can I avoid the error message that occurs when clicking to the next button when the end is already reached. The error says: You can't go to the specific record. I want it to say something different or just not to occur.
THanks in advance !
check this code snippet. What you have to do is before you move to the next record, save the bookmark and then check its EOF. If true then you have to go back to the previously saved bookmark. this is the reason why you are still getting the error.
varBookmark = rs.Bookmark
If rs.EOF Then
rs.Bookmark = varBookmark