Enter an expression in a macro action argument

• Type an equal sign (=) followed by the expression. For example, the following expression sets the action argument to the value of the CompanyPickList control:

  =[CompanyPickList]

There are two exceptions: the Expression argument of the SetValue action, and the Repeat Expression argument of the RunMacro action. If you precede an expression in these arguments with an equal sign, Microsoft Access evaluates the expression twice, which can cause unexpected results.

Tip   In a Microsoft Access database (.mdb), click the Build button to use the Expression Builder. The Expression Builder is not available from a Microsoft Access project.

For more information on setting action arguments in a macro, click .