Microsoft Access 2010 Bible

Part II: Programming Microsoft Access

570

FIGURE 15.13

Hovering the mouse over SetLocalVar

Collapse button Builder button Delete icon

Move arrows

Also, in Figure 15.13, notice the Builder button to the right of the If statement’s conditional

expression box. This button opens the familiar Expression Builder (shown in Figure 15.14) used in

many places in Access.

Macro items (blocks, actions, and so on) can be copied and pasted within the macro. In Figure

15.15, the SetLocalVar macro action has been copied (using the right-click context menu or by

pressing Ctrl+C) and pasted (with the context menu or by pressing Ctrl+V) to a location below the

If block. This action could’ve also been pasted within the If block, if necessary. You can’t have

two local variables with the same name, so in Figure 15.14 the Name box is selected, making it

easy to assign the new variable’s name.