Using checkboxes as parameters

[cuyeda]

I have a query which lists a record of species. Each species has a "species
type" (eg. mammal, turtle, fish, or invertebrate).

A user would only like to search for certain combinations of species types.
So I would like to create a parameter form which allows a user to select any
combination of the species types to search for. I'm thinking of a form which
displays all the species types and then puts a checkbox next to each. If the
user clicks the box it will search for that species. If a user clicks
multiple boxes the query will search for all the species types selected.

For example, if a user clicked "mammal", "turtle" and "fish" I would want
the criteria in the query design view to look like:
"Mammal" Or "Turtle" Or "Fish".

Thanks so much in advance for any assistance. Also please let me know if
I'm going about this the wrong way.

 

[Duane Hookom]

Provide a multi-select list box on your form for selecting species. There are
many resources on the web that outline how to use this type of control in a
query criteria.