I have a form set up to requery every 5 minute and this works fine, but within the form a have a subform with a PivotTable. I would like to stay on the form and have the PivotTable auto refresh at the same time.
I have a button "Edit PivotTable Object" on the subform, and as soon as I click...