I'd like to set up a form and query in such a way that the user can have options for how the query is performed. I'll provide a little bit of detail....
The db involves analyzing quality of manufactured parts. Each part is described by zones - or areas of the part. These zones are assigned numerical values. Sometimes the user is interested in looking at the quality of a single zone, but sometimes he'd like to look at the quality of two or more zones at the same time. Depending upon the part number, the number of zones for the part could range from 8 to 20. The results of the query should show the quality information for all user-selected zones.
I'd like to somehow set up the form so the user can input one or more zones for the select query. This query will also limit what is viewed by a date range, part number, and other parameters. But the need to have any combination of zones is what is giving me trouble.
Ideally, I'd like to have a pick-list on the form and allow the user to hold down some key (like the CTRL key) to select multiple zones. Then set up some kind of code to perform the query on all the choices the user picked.
Any experience with this ?
Thanks in advance !
The db involves analyzing quality of manufactured parts. Each part is described by zones - or areas of the part. These zones are assigned numerical values. Sometimes the user is interested in looking at the quality of a single zone, but sometimes he'd like to look at the quality of two or more zones at the same time. Depending upon the part number, the number of zones for the part could range from 8 to 20. The results of the query should show the quality information for all user-selected zones.
I'd like to somehow set up the form so the user can input one or more zones for the select query. This query will also limit what is viewed by a date range, part number, and other parameters. But the need to have any combination of zones is what is giving me trouble.
Ideally, I'd like to have a pick-list on the form and allow the user to hold down some key (like the CTRL key) to select multiple zones. Then set up some kind of code to perform the query on all the choices the user picked.
Any experience with this ?
Thanks in advance !
