B
bdtmike
Strange one here...
Got a form that's opened as a pivottable. It is based on queries that
get their parameters from yet another form. When I change the
parameters I want to do a form.requery on the pivot table form and have
the data requeried. Turns out that I can fire off the requery method
of the form....the OnQuery event triggers....but the underlying queries
are not rerun.
Very little about this on google or Microsoft. Anyone know how to
solve this problem (other than Shift <F9>)?
Got a form that's opened as a pivottable. It is based on queries that
get their parameters from yet another form. When I change the
parameters I want to do a form.requery on the pivot table form and have
the data requeried. Turns out that I can fire off the requery method
of the form....the OnQuery event triggers....but the underlying queries
are not rerun.
Very little about this on google or Microsoft. Anyone know how to
solve this problem (other than Shift <F9>)?