Examples of referring to controls in expressions - Access

Warning: You are viewing this page with an unsupported Web browser. This Web site works best with Microsoft Internet Explorer 6.0 or later, Firefox 1.5, or Netscape Navigator 8.0 or later. Learn more about supported browsers.

Email this link

Printer-Friendly Version Bookmark and Share

Examples of referring to controls in expressions

Applies to: Microsoft Office Access 2003

Show Referring to controls on a form or a subform

The following table lists examples of expressions you can use in calculated controls on forms.

If you use this expression	Microsoft Access displays
=Forms![Orders]![OrderID]	The value of the OrderID control on the Orders form.
=Forms![Orders]![Orders Subform]![OrderSubtotal]	The value of the OrderSubtotal control on the Orders Subform on the Orders form.
=Forms![Orders]![Orders Subform]![ProductID].Column(2)	The value of the third column in ProductID, a multiple-column list box on the Orders Subform on the Orders form. (0 refers to the first column, 1 refers to the second, and so on.)
=Forms![Orders]![Orders Subform]![Price] * 1.06	The product of the value of the Price control on the Orders Subform on the Orders form and 1.06 (adds 6 percent to the value of the Price control).
=Parent![OrderID]	The value of the OrderID control on the main or parent form of the current subform.

Show Referring to controls on a report or a subreport

The following table lists examples of expressions you can use in calculated controls on reports.

If you use this expression	Microsoft Access displays
=Reports![Invoice]![OrderID]	The value of the OrderID control on the Invoice report.
=Reports![Summary]![Summary Subreport]![SalesTotal]	The value of the SalesTotal control on the Summary Subreport on the Summary report.
=Parent![OrderID]	The value of the OrderID control on the main or parent report of the current subreport.

Show Referring to controls on a data access page

The following table lists examples of expressions that you can use in calculated controls on data access pages.

If you use this expression	The page displays
=Document.All("MSODSC").CurrentSection .ChildSection.HTMLContainer.Children("ProductID")	The value in the ProductID control in the section that is one group level (group level: The depth at which a group in a report or data access page is nested inside other groups. Groups are nested when a set of records is grouped by more than one field, expression, or group record source.) below the current section.
=Document.All("MSODSC").CurrentSection .ParentSection.HTMLContainer.Children("CustomerID")	The value in the CustomerID control in the section that is one group level above the current section.
=Document.All("MSODSC").CurrentSection .Parent.Parent.HTMLContainer.Children("Country")	The value in the Country control in the section that is two group levels above the current section.
=Document.All("MySpreadsheet").Range("A1")	The values in the range A1 in the spreadsheet control.

The following table lists examples of referring to controls on a page from a spreadsheet control.

If you use this expression	The page displays
=document.Quantity.value*document.UnitPrice.value	The result of multiplying the value in the Quantity control by the value in the UnitPrice control.
=$C$1*document.UnitPrice.value	The result of multiplying the value in the UnitPrice control by a percentage rate that is stored in spreadsheet cell C1.

Notes

In a calculated control, precede the expression with the equal sign (=) operator.
When you set the Name property of a calculated control, make sure you use a unique name. Don't use the name of one of the controls you used in the expression.