Refer to the value of a control or property in an expression

You refer to the value of a control or property in an expression by typing its identifier.

To refer to the value of a control

• Type the identifier for the form or report that contains the control, followed by the ! operator and the name of the control. For example, the following identifier refers to the value of the OrderID control on the Orders form:

  Forms![Orders]![OrderID]

  Tip   If you're referring to a control on a subform or subreport, you don't have to specify the full identifier for the form or report using the Form or Report property. For example, you can use the following identifier to refer to the Quantity control on the Orders Subform subform:

  Forms![Orders]![Orders Subform]![Quantity]

To refer to the value of a property

• Type the identifier for the form, report, or control to which the property applies, followed by the . (dot) operator, and the name of the property. For example, the following identifier refers to the DefaultValue property of the OrderDate control on the Orders form:

  Forms![Orders]![OrderDate].DefaultValue

Notes  

• You can use the Expression Builder to create an identifier for a control or property.
  
  
• When you run a macro or Visual Basic for Applications code containing an expression that refers to a form or report, the form or report must be open.

For more information on creating an expression using the Expression Builder, click .

For more information on using identifiers in expressions, click .

For more information on using values in expressions, click .

For more information on referring to a form, report, subform, or subreport in an expression, click .