Examples of referring to controls in expressions

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.

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.

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 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.