RandyHarding
New member
- Local time
- Today, 16:10
- Joined
- Dec 28, 2007
- Messages
- 3
In Access 2007 I have created a (parent) form which contains four subforms. The subforms were created using the Pivot Chart wizard. I need to communicate a change in the filter field (this is the field at the top left on the chart) to the other pivot charts (subforms) on the (parent) form.
The filter field on each pivot chart is a dropdown of dates. If a different date is selected on one pivot chart I want the filter field on all the pivot charts to be changed automatically.
Is it possible to reference and set the filter field in VBA code and, if so, how is it done?
The filter field on each pivot chart is a dropdown of dates. If a different date is selected on one pivot chart I want the filter field on all the pivot charts to be changed automatically.
Is it possible to reference and set the filter field in VBA code and, if so, how is it done?
