Form w/a combo box to execute a parameter query

Kylor

Registered User.
Local time
Today, 13:40
Joined
Dec 14, 2000
Messages
17
I am creating a directory. I would like the users to be able to select a category from a drop down list on a form(categories pulled from a field on the table), select the category, and have Access provide a report of the findings of the parameter query (address, phone ect).
 
All you need to do is put the form and control name as the criteria of the category field in your query. The syntax is
forms!YourFormName!YourCategoryDropdown

Access will even add the brackets for you.
 

Users who are viewing this thread

Back
Top Bottom