By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,426 Members | 1,689 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,426 IT Pros & Developers. It's quick & easy.

Changing Access Charts Using Combo Boxes

P: n/a
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
Nov 13 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.