Refresh PivotChart subform

[Bob McClellan]

I have a main form with two subforms.

One subform has a list that allows the user to select a class type.
the other is a PivotChart.

How can I have the PivotChart subform refresh by clicking on the
1st subforms class type.

I've never worked with PivotChart subforms. On any other types of
subforms I simply change the 2nd form's inputparameters in the
1st forms OnCurrent event.

Trying this on the pivot chart simply blanks the PivotChart subform.

Any help with this would VERY MUCH be appreciated.
Thanks in advance!
...bob

 

[Tom van Stiphout]

On Thu, 12 Nov 2009 17:08:16 -0500, "Bob McClellan"

I've never done that either, but I think this would work:
Me.mySubformControl.Form.Requery
Or perhaps:
Me.mySubformControl.Form.myPivotChart.Requery

-Tom.
Microsoft Access MVP

 

[Bob McClellan]

Thanks for the reply Tom.
I tried the requery and the refresh.
Neither has any impact. It's like there
needs to be a Rerender method or something like that.

thanks again,
...bob

 

[Bob McClellan]

I wound up setting it up so that when you double click
the ClassDescription on the form, the OnDoubleClick event
opens the pivotchart form.
the Inputparameter for the form points at the ClassDescription that
was double clicked. The chart opens with the correct plot.
I really wanted to have this reside as a 2nd subForm on the same
main form. My intent was to have the inputparameter change with the
OnCurrent event of the 1st subform.

If you get a chance to play around with this Tom and figure out how to
make it work I'd sure appreciate knowing how to put this in place.

Thanks in advance,
...bob