Subform on a Report, Link Master/Child filtering and PivotChart

[Kyle Jedrusiak]

I have a PivotChart form. In order to get the chart to look the way the
client wants, I create the chart programatically.

I have that PivotChart form as a subform on a report.

I have the Link Master and Child fields set to the correct fields.

If I show the PivotChart form as a regular form just showing the fields, the
filtering from the Linked Master/Child works.

What event do I need to capture in order to rebuild the pivot chart based on
the Linked Master/Child filtering?

Thanks

Kyle!

 

[Guest]

Hi Kyle,

Generally, if the form view is updating, your pivot chart should as well.

Is your pivotchart not redisplaying with the updated linked records when you
move through the parent records one-by-one? Can I assume you are coding the
re-query on the record change?

John_Lehmus
Maine, USA