Graph Based On Select Record

[OZmc]

What i have:

1. I ahve a select query that displays ALL [names] their [values] and the [date] when it was recorded. Several [names] have multiple records and thus multiple [values]
2. I have a report based off this query. the report takes this data and graphs it.

The problem:

1. as the database grows in records [names] the graph becomes crowded.

what i need help with:

1. I would like to have a form for the user where they select from a dropdown list which record [names] they want to graph.
2. this will cause the query to only display records from the dropdown list.
3. This will cause the report to only graph a desired record.

can someone point me in the right direction. I dont know how to make a query look for records based off of a select record in a dropdown list.

 

[JHB]

You have to build the query string in a module/code.
Use a do - loop, until all selected name in the list are picked up and insert in the query string.