Using Combo Box to aid search

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
SELECT * FROM YourTable WHERE YourField = Forms!YourForm!YourComboBox

The form must be open when the query runs.

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


Norm Henderson said:
I am using Access 2002 and have a database with about 200 names.
Click to expand...
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?
 
Back
Top