DoCmd.RunMacro method (Access)

The RunMacro method carries out the RunMacro action in Visual Basic.

Syntax

expression. RunMacro( _MacroName_, _RepeatCount_, _RepeatExpression_ )

expression A variable that represents a DoCmd object.

Parameters

Name Required/Optional Data type Description
MacroName Required Variant A string expression that's the valid name of a macro in the current database. If you run Visual Basic code containing the RunMacro method in a library database, Microsoft Access looks for the macro with this name in the library database and doesn't look for it in the current database.
RepeatCount Optional Variant A numeric expression that evaluates to an integer, which is the number of times the macro will run.
RepeatExpression Optional Variant A numeric expression that's evaluated each time the macro runs. When it evaluates to False (0), the macro stops running.

Remarks

You can use the RunMacro method to run a macro.

You can use macrogroupname. macroname syntax for the macroname argument to run a particular macro in a macro group.

If you specify the repeatexpression argument and leave the repeatcount argument blank, you must include the repeatcount argument's comma. If you leave a trailing argument blank, don't use a comma following the last argument you specify.

Example

The following example runs the macro Print Sales that will print the sales report twice:

DoCmd.RunMacro "Print Sales", 2

See also

DoCmd Object