Hello Access Expert,
I have created a PivotChart Form.
In the Open Event of the form I would like to Select specific categories determined at runtime for each of the Drop Zones / Filter Combo Boxes.
So for example if one of the Filter Combo Boxes has a list of Provinces I want to be able to deselect some and select others using VBA before the PivotChart Opens.
For the other Filter Combo Boxes (i.e Year) I always want All Selected before the PivotChart opens.
Can you provide some VBA examples or point me to some websites that have VBA examples to do the above?
The examples I have seen on the web add data to the Chart. I have all the data in the underlying query. I just need to control the selections in the Filter Combo Boxes using VBA.
Thank you
I have created a PivotChart Form.
In the Open Event of the form I would like to Select specific categories determined at runtime for each of the Drop Zones / Filter Combo Boxes.
So for example if one of the Filter Combo Boxes has a list of Provinces I want to be able to deselect some and select others using VBA before the PivotChart Opens.
For the other Filter Combo Boxes (i.e Year) I always want All Selected before the PivotChart opens.
Can you provide some VBA examples or point me to some websites that have VBA examples to do the above?
The examples I have seen on the web add data to the Chart. I have all the data in the underlying query. I just need to control the selections in the Filter Combo Boxes using VBA.
Thank you