I'm trying to requery a pivot chart without closing and re-opening the form, but not having any luck.
If I change the recordsource directly (forms!mychart.recordsource = "select blah from stuff") then the chart loses all it's formatting, and everything useful. Can't do that.
If I base the pivot chart on a query and change the query's sql, then requery the form, nothing happens. The query def changes correctly, but the form / pivot chart doesn't respond to a forms!mychart.requery - it gives an hourglass for a few seconds, but no new data!
The only way I've been able to get new data into a pivot chart is to re-open the form, but that's incredibly dodgy, and very slow.