Cross-post: Updating pivot form programmatically

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I've seen several people ask this question recently, but none of them have
received replies. Perhaps this is impossible?

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 changing 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?

By the way, I know that I can go through the process of Open the Pivot Chart
-> Refresh data within Excel -> Close the Excel embed. I obviously don't
want to force the user to go through all that.


Thanks
 
hi Rob,
This isn't working either. At this point, I'm pretty much flailing about.
Anyone know the secret?
Click to expand...
I never used pivot forms, but pivot queries: you need to reopen them, to
reflect your data changes.


mfG
--> stefan <--
 
Back
Top