Query: input parameter that user can select from a predefined list

[alanon]

Hi all,

I need some help; I need a Query that a user can run, requires an input parameter from the user, and that parameter needs to match from an existing predefined list.

ie:
-a user has inputted 500 records into a db with each record selecting 1 of 12 existing categories.
-The user wants to view the records for a specific category
-the next day he decides he wants to view the records from another category.
-However that user can’t remember the exact name of each category
-he wants to be able to click one of them to view the records with that category.

Can anyone help me with how to write the Criterion that would show such a list? Is it possible? The only other solution I can come up with is writing a Query for each category which would work, but be a little cluttering on the Queries list.

Thank you in advance!
alanon

[Ratslinger]

A query is probably not the best for this. It would be better in a form using a filter. See answer in this post (click here) for link to filtering explanation and the sample “BikeDemo2” form “Bike2” demonstrates a filter.

Edit:

This sample may be more in the way of what you want. See form “Bike4” in the sample.

Bike4.odb