Pivot Form requery

R

Rob

I have a Pivot Form in Access 2000 that I've made into a nice little pivot
chart. I have another form that updates the data in the pivot form query, so
in that code I've added

Form_PivotTableForm.Requery
Form_PivotTableForm.Refresh

hoping that chaging the data will automatically update the chart. It doesn't.
I've also tried requerying and updating the data in the pivot table object
itself:

Form_PivotTableForm.PivotTable.Requery
Form_PivotTableForm.PivotTable.Action = acOLEUpdate

This isn't working either. At this point, I'm pretty much flailing about.
Anyone know the secret?

Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Embed OLE Excel Pivot Tables in Access Forms? Access v2003 and ff. 0
Embed OLE Excel Pivot Tables in Access Forms? Access v2003 and ff. 0
subform based on external SQL won't requery 1
How do I clear a form? 0
requery continuour subform 11
Requery table from form 4
Using VBA on Excel Pivot Tables 3
Access 2003 pivot table subform 0

Top