Create a macro group

Create a macro group

If you want to group several related macros in one place rather than keeping track of them separately, you can organize them as a macro group.

  1. In the Database window, click Macros under Objects.

  2. Click the New button on the Database window toolbar.

  3. Click Macro Names on the toolbar, if it isn't already pressed in.

  4. In the Macro Name column, type a name for the first macro in the macro group.

  5. Add the actions you want the macro to carry out.

    How?

  6. Repeat steps 4 and 5 for any other macros you want to include in the macro group.

Note   When you save the macro group, the name you specify is the name of the group of macros. This name is displayed in the list of macros and macro groups in the Database window. Whenever you refer to a macro in a macro group, use this syntax:

macrogroupname.macroname

For example, Buttons.Products refers to the Products macro in the Buttons macro group. In a list of macros, such as the Macro Name argument list for the RunMacro action, Microsoft Access displays the Products macro as Buttons.Products.