drop down list

#1 (**permalink**) 28-Jul-2006, 08:28 AM

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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/12325-drop-down-list.html
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12325
and then the query will run. Thanks

*

#2 (**permalink**) 28-Jul-2006, 08:28 AM

On Thu, 29 Jun 2006 09:22:02 -0700, Pam Coleman wrote:

> 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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12325
> 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"
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12325
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.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail