drop down list

[Pam Coleman]

on a startup form I want to create a button that will let you choose from a
drop down list and when you click on that choice, it will run the query?

I have a list of departments (15), Information & Techonology, Administrative
Services - Fiscal (example) (long names) and if I have a parmeter set up to
Enter the name and part of it is left out or misspelled it will not run. I
just want the user to click on a drop down arrow and choose the department
and then the query will run. Thanks

 

[fredg]

on a startup form I want to create a button that will let you choose from a
drop down list and when you click on that choice, it will run the query?

I have a list of departments (15), Information & Techonology, Administrative
Services - Fiscal (example) (long names) and if I have a parmeter set up to
Enter the name and part of it is left out or misspelled it will not run. I
just want the user to click on a drop down arrow and choose the department
and then the query will run. Thanks

Add a combo box to your form that will show the Department field.
Make sure the Combo Box Bound Column is the
same DataType as the Department field.

Add a command button.

Code the button's Click event:
DoCmd.OpenQuery "QueryName"
DoCmd.Close acForm, Me.Name

Name this form "ParamForm"

Code the Query Department field criteria line:
forms!ParamForm!ComboBoxName

Open the form.
Find the Department in the combo box.
Click the command button.

The query will display just those records selected.
The Form will close.