Datasheet

Chapter 1
38
10.
This will, in turn, bring up the Choose Builder dialog. For the moment, we want to use
a macro, so select Macro Builder and hit the OK button:
11.We've said that we want a macro behind the button, so Access now helps us to build
it. It displays the macro design window and prompts us for the name that we want to
give the macro. We will call it macNextButton, so you should type in macNextButton
and then press OK.
12.Now we get to specify the macro commands that will be carried out when we hit the
command button. We want the button to make the form go to the next record. To get it
to do this, you must click the down arrow in the Action column and select
GoToRecord from the drop-down list that appears:
13.We then need to specify which record we want the command button to move us to.
Click in the Record box in the lower pane of the screen, click the down arrow and
select which record you want to go to from the drop-down list. We want to go to the
next record, so make sure Next is selected. In fact, Next is the default selection in the
drop-down list: