Refer to a form, report, subform, or subreport in an expression

You refer to an open form or report, or the subform or subreport of an open form or report, in an expression by typing its identifier.

To refer to an open form or report

• Type the name of the Forms or Reports collection, followed by the ! operator and the name of the form or report.

  For example, the following identifier refers to the Orders form:

  Forms![Orders]

To refer to a subform or subreport

Refer to the subform or subreport control on the form or report that contains the subform or subreport, then use the Form or Report property of the control to refer to the actual subform or subreport.

• Type the identifier for the form or report that contains the subform or subreport, followed by the name of its subform or subreport control, the . (dot) operator, and the Form or Report property.

  For example, the following identifier refers to the Orders Subform subform on the Orders form:

  Forms![Orders]![Orders Subform].Form

Notes  

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