Hands-On Microsoft Access: A Practical Guide to Improving Your Access Skills

Case Example

In Chapter 11, “Forms/Subforms,” you learned how to create a form/subform. The subforms you created were in Datasheet view, but they could have also been displayed in PivotTable view or PivotChart view. As you move from record to record in the main form, the subform's pivot table or pivot chart changes to correspond to the main record.

In the following example, you'll use the Form Wizard to create a form with a subform. You'll then design the pivot chart.

1.	In the Database window, click Forms. Double-click Create Form by Using Wizard.
2.	Open the drop-down list and select Table:tblOrders. Add all the fields to the Selected Fields pane.
3.	Open the Tables/Queries drop-down list and select Table:tblOrderDetails. Add the OrderID,