Microsoft Access 2010 Bible

Chapter 30: Using Access Macros

1057

FIGURE 30.6

mcrBackupContactsAndProducts archives data from the live tables into the backup tables.

Macro action argument

Potentially unsafe actions

Submacros

When automating your application with macros, you might easily get carried away filling the

Navigation Pane with a bunch of little macros for opening every form and every report. Submacros

are the equivalent of subroutines. If you have a series of actions that are performed in a number of

places, ideally you only want one copy, so that you need to make changes only in one place.

Submacros give you that capability: You define the series of actions in one place as a submacro,

and then invoke that submacro wherever it’s needed. Only the submacro object appears in the

Navigation Pane, rather than multiple smaller macros.