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
 
Top