Hello,
I am trying to create a chart whose underlying query is linked to 2
combo boxes on the same form.
I want to pass the values from the combo boxes into the chart query to
allow the chart data to be manipulated easily.
The combo box uses "Row Source Type" = Table/Query. The "Row Source"
references a query to extract a distinct list of data.
After making a selection for the first Combo box, I want the second
combo box to populate with a data set of the query result from the
previous combo box.
E.g.
The base query selects all data; Combo Box 1 contains all the unique
countires in the query set, after selecting country "UK", the 2nd
Combo box contains only the unique years data relevant to "UK".
Once the cobmo boxes have been selected, I want the Chart to update
accordingly i.e. by passing the combo box values into the query that
lies beneath the graph.
I have tried doing this using the Link Child Fields and Link Master
Field properties of the Chart. It seems to work OK initially, however
when I save the form and re-open, I get the following error message
"3637 Cannot use the crosstab of a non-fixed column as a subquery".
I'm not sure what this error means - think it relates to the Query
within the Chart row source.
Any help on this approach to dynamic charting or any other approaches
would be gratefully received
Regards
Andy