Access 2016 Advanced
Lesson 1 - Using Subforms/Subreports
Access 2016
Open the Product List form in Design view.
Steps
Practice Data
1. On the Design tab in the Controls group select the Text Box button. The mouse pointer changes into a text box with a plus sign (+) when positioned over the form. 2. Click in the form or report where you want to insert the control. The control appears on the form or report.
Click
Scroll as necessary and click in the form below the subform, in line with the 3.5” mark on the horizontal ruler
3. Select the label field.
Click in the label box
Sizing handles appear around the label field.
4. Drag to select the text in the label field. The text is selected.
Drag to select Textxx: ( xx is a number)
5. Type a label in the label field.
Type Items Total
The label appears in the label field.
6. Select the text box.
Click in the text box
Sizing handles appear around the text box.
7. Press [F4] to open the property sheet. The property sheet for the selected text box opens.
Press [F4] , if necessary
8. Select the Data tab.
Click the Data tab, if necessary
The Data page appears with the insertion point in the Control Source property. 9. Type the expression that refers to the desired subform/subreport control. The expression appears in the Control Source property. 10. Press [F4] to close the property sheet. The property sheet closes, and the expression replaces the text in the text box.
Type = [Order Items of Company]![Total]
Press [F4]
Page 12
OFFICEPRO, Inc.
Made with FlippingBook - Online magazine maker