Generating a graph from a query that uses a combo box to determine the criteria

  • Thread starter Christopher W via AccessMonster.com
  • Start date
C

Christopher W via AccessMonster.com

The issue that plagues me is trying to get a graph to interact with a query
by using a combo box to determine the criteria. The theory being that the
user could enter a page select the item that they wish to view the graph from
and then hit a graph button and launch the graph. I can do this by separating
them and having a different graph for each but this doesn’t allow for
additions and removals of items, so the combo box is very preferable.

The graph and the query all work perfectly until I try and get the query
(therefore the graph) to alter when I put the combo box in as criteria.
 
M

[MVP] S.Clark

Keep in mind that the Graphing Application is specific to Office, not
Access. So, trying to use something like a parameter query may not work.
You may need to write the data, based on the criteria, to a temp table, then
base the graph on the table, and not a query.

--
Steve Clark, Access MVP
FMS, Inc.
Call us for all of your Access Development Needs!
1-888-220-6234
[email protected]
www.fmsinc.com/consulting
 
Top