Microsoft Office Tutorials and References
In Depth Information
Text box control’s expression in the Expression Builder dialog box
Access changed the pasted txtInvoiceNumCount to [frmInvoiceSubform].Form!
[txtInvoiceNumCount]. This expression asks Access to display the value of the
txtInvoiceNumCount control that is located in the frmInvoiceSubform form, which
is a form object.
You need to add an equal sign to the start of the expression.
5. Press the Home key, click the = button in the row of operators to the left of the
Paste button, and then click the OK button. Access closes the Expression Builder
dialog box and sets the Control Source property.
Next, you’ll add a second text box to the main form, set the Caption property for
the label, and use Expression Builder to set the text box’s Control Source property.
6. Repeat Steps 1 through 3 to add a text box to the main form, clicking the + portion of
the pointer at the 5-inch mark on the horizontal ruler and the 2-inch mark on the verti-
cal ruler, and setting the label’s Caption property to Invoice Amount Total: .
7. With the Expression Builder dialog box open for the new text box, click the = button to
insert an equal sign in the large text box, double-click frmContractsAndInvoices in
the left column, click frmInvoiceSubform in the left column, scroll down the middle
column, click txtInvoiceAmtSum in the middle column, and then click the Paste
button. Access changed the pasted txtInvoiceAmtSum to the expression
Next, you’ll save your form changes and view the form in Layout view.
8. Close the Expression Builder dialog box, close the property sheet, save your form
changes, and then switch to Layout view. See Figure 6-43.