Microsoft Office Tutorials and References
In Depth Information
3. Drag the Submacro action to your macro.
Access puts all submacros at the bottom of your macro and creates a
group, with a name and actions, as shown in Figure 1-3.
Another way to make a submacro is to right-click anywhere in your
macro and choose Make Submacro Block from the contextual menu.
as you want.
4. Type a name for the submacro in the Submacro box.
5. Enter the macro’s actions and arguments inside the submacro area
by making choices from the Add New Action drop-down menu or by
dragging actions into the submacro area from the Action Catalog.
When you run a submacro, you specify the name of the macro followed
by a dot and the submacro name. If you’re working on a set of macros for
use on your Orders form, you could call the macro OrderForm. One
submacro might be the actions required to print an invoice; if you name that
submacro PrintInvoice, the submacro’s full name is [OrderForm].
[PrintInvoice]. (The square brackets are required for names that include
spaces, and using them isn’t a bad idea anyway.)
Refer again to Figure 1-3, which shows a macro with three submacros. The
first one is expanded so that you can see its actions, whereas the other
three are collapsed so that only their names appear. To expand a collapsed
submacro (which sounds like a medical condition, doesn’t it?), click the plus
box to the left of the submacro’s name.