How to use list from combo box as critera to run a select query

[bobdean]

First of all I'm very new to using access. I have created a combo box (combo14) that list all of the services in my organization.

i want to be able to run a query where the combo box pops up and users can pick from the list of oranizations to use as criteria in the query. help please?

[Jerry Maiapu]

1.First you can store all the services in a table.
2. create a combo box:
3. On its row source select your services table and click the build button and select the fields from the table.
Alternatively, if the use control wizard button is enabled,you can create a combo using wizard and select the services table and select the fields.//I know you did this but just to be on safe side.

Now on the query criteria use this format to get the value from the form into the query to filter the query.

Forms![name of your form]![combo14].

That is it!
After you select a value from the combo, run the query, the query will filter its results based on the service name selected from the combo.