Modify PivotChart Filter VBA

[Catch Wrestler]

I have a PivotChart on a form. I would like to format that charts filter via VBA. Right now I am filtering on 'ChartOrder' which is an integer. I would like to dynamically increment that integer after each print event.

For example... I want to run the module that will load the PivotChart, print it, increment the 'ChartOrder' filter by one, print it, etc etc etc.

[llkhoutx]

Use a query as the record source and then dynamically modify the query for each successive chart.