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

  • Thread starter Thread starter Kyle Jedrusiak
  • Start date Start date
K

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!
 
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
 
Back
Top