O'Reilly logo

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

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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,

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required