Microsoft Office® Access 2007 Inside Out

Defining Multiple Actions

In Access 2007, you can define more than one action within a macro, and you can specify the sequence in which you want the actions performed. The Wedding List Macro database contains several examples of macros that have more than one action. Open the database if it is not open already. Click the Navigation menu at the top of the Navigation Pane, click Object Type under Navigate To Category, and then click Macros under Filter By Group to display a list of macros available in the Wedding List Macro database. Right-click the macro named AutoexecXmpl, and then click Design View on the shortcut menu to open the Macro window. Figure 18-7 shows the macro.

Figure 18-7. The AutoexecXmpl macro defines multiple actions that Access ...