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.