Multivalue search form

[iPete]

I'm not sure if this is possible. Google isn't throwing up much but it could be my terminology letting me down.

I've created a search form to a sub-table that is working well across many combo boxes.

However, as is the way my team have asked to be able to select several options in a dropdown. Is this possible in Access and if so, how? Large amounts of coding or something simpler [fingers crossed]?

Example: They would like to be able to search for the status On Target and Behind Target.

[TG_W]

Have them type the wildcard in the box, like *Target*. It should pull both up. Just because there is a drop box doesn't mean they can't type something in. Now, this only addresses the particular example given. Of course, if you're dealing with engineers, they're just trying to be difficult because they don't want to learn something new

Hope that helps some.