Forms w/ Line Chart????

[John64]

I am new to access and am attemptin to create a line chart in a form. Currently I am able to run a wizard which will plot the data, but it will plot all of the possible "series" that are found in the column of the table I am plotting from. What I really want is to be able to create 'combo boxes' that allow the user to choos a single series that they would want to plot, and also a beginning and start date for the line to plot to. I can create combo boxes but have no clue how to link them to the line chart. Can someone please point me in the right direction? Am I even taking the right approach?

 

[lark_tilly]

You would need to create a query that uses your combo boxes as criteria.
Then set up your chart with the query as it's data source.

 

[John64]

I am having an extremely hard time figuring this out. I have looked and tried almost everything. I have no problems charting the data, but getting the chart to recognise any criteria I type into the query is impossible. I currently have the following line of code in my queries criteria.

[Forms]![Form1]![Text1]

This code does work to update the query. Any criteria I type in the form will update the query with the new criteria, but when I insert a chart into my form, i get an error that this is "not a valid name or expression". What code should I be using or is it even possible to get this to work with this approach. I have been studying the below thread but his criteria give me the same error when using a line plot. Any help would be appreciated?

http://www.access-programmers.co.uk/forums/showthread.php?t=165771

 

[GaryPanic]

have a look at the attached


this is a pie chart but still works

Data
Currecny
contract *
Amount *



* are the chart and currency the variable

so a list box on currecy
and qry to make the charts

version A2000

 

[John64]

Thank You very much I finally got some stuff to work!