I created a pivot table and saved it as a form.
The form is opened with a command button with one line of code:
DoCmd.OpenForm "frmTheForm", acFormPivotTable, , , acFormReadOnly, acWindowNormal
Works well for the users ... with one problem.
Each supervisor opens the pivot table and specifies the criteria they are interested in by using the drop down menus of the pivot table. This usually involves looking at employees in their department or filtering to see only a certain job title. When the pivot table is closed ... the next person who opens the pivot table sees the previous person's criteria and not all of the data.
I would like the pivot table to open without any specific criteria and simply display off of the availble data.
Any help on how to open the pivot table so all of the data is diplayed would be appreciated.