Microsoft Access VBA Programming for the Absolute Beginner

Runs a macro.

Syntax

DoCmd.RunMacro MacroName[, RepeatCount][, RepeatExpression]

with the following parameters:

MacroName

A String defining the name of the macro in the current database to run.

RepeatCount

An Integer indicating the number of times the macro is to run.

RepeatExpression

A numeric expression that causes the macro to terminate when it evaluates to 0 (or False).

Comments

• MacroName can use the MacroGroupName.MacroName syntax to run a particular macro in a macro group.

• If both RepeatCount and RepeatExpression are omitted, the macro runs once.

• If both RepeatCount and RepeatExpression are used, the macro runs RepeatCount times or until RepeatExpression is False, whichever occurs first.