Using a listbox to select data for a chart

[beakerboy]

Hey there all.
I'm setting up a database to organize a collection. I have a table of items, dates and prices. I would like to be able to display a chart with the price of each item over time. I was hoping I could either use a listbox to select which item to display, or use the record selector on the bottom of the frame.

I can generate a graph with all the items just fine, so how do I pass the listbox value to the query in order to filter out the data I want.

If this can not be done, please tell me that too.
Thanks all,
Kevin

 

[Aivars]

Hi, Kevin!

Create subform based on needed data for charts. Create Links between Main form and Sub Form.

Me.subTest.LinkChildFields = "MyItem"
Me.subTest.LinkMasterFields = "lstMyListBox"

Generate a graph based on sub form.

Aivars