Examples of referring to controls in expressions

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.

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.

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