Creating Conditional Macros

Sometimes you may want a macro to run only if some prior condition is met. For example, you could create a macro that prints a report only if the number of records to print is greater than zero. You can do this by creating a conditional expression, an expression that Access evaluates as true or false. If the condition is true, Access carries out the actions in the macro or macro group.

Create a Macro Condition

Open a macro in the Macro window.

Click the Conditions button on the Macro Design toolbar.

Click the Build button on the Macro Design toolbar to open the Expression Builder.

Enter an expression that Access could evaluate as either true or false.

Click OK.