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:
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.
Please respond only to this newsgroup.
I do not reply to personal e-mail