M
Marcus
Good morning,
I'm having some little problems using pivotcharts in Access 2003 + latest
patches.
Goal: show a chart whose recordsource is a query that changes depending on
current record
- I' have designed a main form with tabs
- one of the tabs must show the chart
- I have designed a subform with pivotchart view
- the subform/pivotchart is built on a query
- I have dragged the subform/pivotchart into the main form
- once running, when current record changes, the pivotchart shows the same
graph, nothing changes.
So I thought: the subform/pivotchart recordsource/query must be updated
somewhere, to apply a "WHERE" clause, to filter out unwanted data, depending
on the current record in the main form.
Problems:
1) If a change (VBA) the "SELECT" subform's recordsource within the main
form code (in the Current event), the subform/pivotchart shows empty...
maybe changeing the subforms/pivotchart recordsource on the fly, spoils the
pivotchart layout?
2) Tried to stick with the linkchild/linkmaster technique, but get errors
(maybe it's a wrong technique, because the subform/pivotchart source is not
a table but a query?
Conclusion:
- How can i solve the problem?
- Should I use a OWC pivotchart object in place of the subform/pivotchart,
and VBA-controlling the pivotchart?
- Any samples?
Thanks
I'm having some little problems using pivotcharts in Access 2003 + latest
patches.
Goal: show a chart whose recordsource is a query that changes depending on
current record
- I' have designed a main form with tabs
- one of the tabs must show the chart
- I have designed a subform with pivotchart view
- the subform/pivotchart is built on a query
- I have dragged the subform/pivotchart into the main form
- once running, when current record changes, the pivotchart shows the same
graph, nothing changes.
So I thought: the subform/pivotchart recordsource/query must be updated
somewhere, to apply a "WHERE" clause, to filter out unwanted data, depending
on the current record in the main form.
Problems:
1) If a change (VBA) the "SELECT" subform's recordsource within the main
form code (in the Current event), the subform/pivotchart shows empty...
maybe changeing the subforms/pivotchart recordsource on the fly, spoils the
pivotchart layout?
2) Tried to stick with the linkchild/linkmaster technique, but get errors
(maybe it's a wrong technique, because the subform/pivotchart source is not
a table but a query?
Conclusion:
- How can i solve the problem?
- Should I use a OWC pivotchart object in place of the subform/pivotchart,
and VBA-controlling the pivotchart?
- Any samples?
Thanks