K
kissybean via AccessMonster.com
Hi all,
How do you refresh data on pivot table form in Access:
According to access help:
"Each time you open a PivotTable form, the PivotTable form shows you the data
that was current the last time you activated the PivotTable form. To display
the most current data in the PivotTable form, you need to update the data."
to do this you have to:
"Open the PivotTable form in Form view.
Click the Edit PivotTable Object button.
On the Data menu in Microsoft Excel, click Refresh Data."
I don't want this at all - does anyone know how to do this programmatically
in the form load event within Access so the data is always current when the
form opens?
Thanks!
How do you refresh data on pivot table form in Access:
According to access help:
"Each time you open a PivotTable form, the PivotTable form shows you the data
that was current the last time you activated the PivotTable form. To display
the most current data in the PivotTable form, you need to update the data."
to do this you have to:
"Open the PivotTable form in Form view.
Click the Edit PivotTable Object button.
On the Data menu in Microsoft Excel, click Refresh Data."
I don't want this at all - does anyone know how to do this programmatically
in the form load event within Access so the data is always current when the
form opens?
Thanks!