Using Combo Box to aid search

[Norm Henderson]

I am using Access 2002 and have a database with about 200 names. Incorporated into the database are keywords which are used to represent the skills that each person possesses. Each person could have 8-10-12 different keywords. It is necessary to do searches for specific skills using the keywords. In the database there are about 200 keywords. Currently I am using the typical query with the [Enter Skill] as the criteria. This necessitates typing the keyword each time. I know I can't incorporate a combo box into the query. However, is there a way I can use a combo box in a form to help me with the search?

Many thanks for your help. Norm.

 

[Brendan Reynolds \(MVP\)]

SELECT * FROM YourTable WHERE YourField = Forms!YourForm!YourComboBox

The form must be open when the query runs.

--
Brendan Reynolds (MVP)
(e-mail address removed)

I am using Access 2002 and have a database with about 200 names.

Incorporated into the database are keywords which are used to represent the
skills that each person possesses. Each person could have 8-10-12 different
keywords. It is necessary to do searches for specific skills using the
keywords. In the database there are about 200 keywords. Currently I am
using the typical query with the [Enter Skill] as the criteria. This
necessitates typing the keyword each time. I know I can't incorporate a
combo box into the query. However, is there a way I can use a combo box in a
form to help me with the search?