Use the form wizard to create a form that displays all the data you want in
the Pivot Table. While still in design view, open properties, go to the
Format tab and set the Default View to Pivot Table.
Note: You can open a form in Pivot table view with:
DoCmd.OpenForm "MyForm",acFormPivotTable