Navigation Buttons on a Form

Besom13

New member
Local time
Tomorrow, 03:10
Joined
Sep 20, 2012
Messages
6
I have a form that collects the data for a Table that contains a date field and 3 memo fields. I have placed the buttons for First record; Previous record; Next Record; and last Record on the form.
In the form properties list I have said 'Yes' to Navigation Spinner.
The problem is that if I use my buttons with embedded Macros I get "Error 2489" whereas if I use the navigation spinner that is at the bottom of the form I easily travel from one record to another.
How do I avoid "Error 2489" when using my buttons? Please.
 
There's an excellent article in VBA help called 'Elements of Run-Time Error Handling.' Use that as your search term.

You can also test for .eof or .bof and disable the appropriate button. There are few options.
 
As recommended yesterday I went to VBA (Examples of Run Time Errors) and read through several of the error messages. It gave me the idea that I was not following the explicit instructions of the error message when Microsoft Access told me to open the form that I was already in. This illogical statement made me hesitate to follow the explicit instructions.
I remedied my button problem on my form by building the Macro by starting to open the form that I was 'already in', then asking the macro to 'go last' or 'go first' or 'go next' after that ‘Build’. This seemingly odd setup of having to open the form where the buttons already reside is probably due to the fact that the form contains in it memo fields - three in fact.
Again thanks for your help - my problem is solved.
 

Users who are viewing this thread

Back
Top Bottom