Microsoft Access 2010 Bible

Chapter 30: Using Access Macros

1059

Next, the developer selected Submacro a second time from the Add New Action list, and pro-

vided OpenProduct as its name. None of the arguments for the second submacro has been

filled in.

The confusing thing about submacros is that you see two Add New Action lists in Figure 30.7.

One is at the very bottom of the main macro, while the second is inside the second submacro.

The submacro that is currently being developed (OpenProducts) is enclosed in a box, while the

completed submacro (OpenContacts) at the top of the main macro is not contained in a box.

FIGURE 30.7

Using submacros to individually open three forms

Main macro

Add New Action list

Submacro OpenProduct

Submacro open controls

Note
In Figure 30.7, notice the small minus sign to the left of Submacro in the first line of the macro. The minus
sign is there to show you that the submacro is currently expanded so that you can see all the steps in the sub-
macro. Clicking on the minus sign collapses the macro to a single line, which lets you view more of the macro
and its actions in a single glance. Several figures in this chapter show macros with portions collapsed (identifi-
able by the small plus sign to the left), so don’t be confused if it appears that portions of a macro illustrated in
a figure appear to be missing.