Using a Parameter Pop Up Screen with a Combo Box

[instructorgirl]

I currently have a query that contains a parameter box. The problem is that there are many choices that could be entered into the pop up box. The users may not know the proper nomenclature to enter. Is there a way to generate an input screen with a combo box button so that they can select from the list? Is this something that will need to be coded with VBA? Any help would be appreciated. Thanks!

 

[Remou]

Hi
You could create a form. The parameter would then look like:
[tt]=Forms![MyForm]![cboMyCombo][/tt]

 

[instructorgirl]

I created by form with the combo box and entered it in the query as you suggested. When I run the query I get the parameter box with the criteria:

[Forms]![frmProductLineLookup]![cboProductLineCode]
in the window. Should this be displaying the form that I created? I noticed that if the form is open and I make a selection from the combo box and THEN run the query, I get a record set of the selected item from the combo box. How do I get the form to pop up when I run the query?

 

[lespaul]

the form has to be open BEFORE you run the query. How are you running the query?

Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

 

[PHV]

Simply launch the query in the Click event procedure of a button in your form.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[instructorgirl]

It is attached to a macro that is being selected by clicking on a button from the switchboard. Should I add an open form macro action before I run the query?

 

[instructorgirl]

Thank you both for your help. This works great!