Pull down list in a query

[Louie]

Is there a way to have a pull down listing in a queries
result?
I have a query that I use to pull all Approved Orders. I
would then like to be able to select from the CircuitID
field and have the query to show only the Approved order
for that CircuitID.
Thank you for you help..

 

[Fredg]

Louie,
You'll need to use a form to do this.

Make a new unbound form.
Add a combo box that will show the CircuitID field.
Make sure the Combo Box Bound Column is the
same DataType as the CircuitID 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 CircuitID field criteria line
forms!ParamForm!ComboBoxName

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

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

 

[Louie]

Thank you Fred.

-----Original Message-----
Louie,
You'll need to use a form to do this.

Make a new unbound form.
Add a combo box that will show the CircuitID field.
Make sure the Combo Box Bound Column is the
same DataType as the CircuitID 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 CircuitID field criteria line
forms!ParamForm!ComboBoxName

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

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

Please reply only to this newsgroup.
I do not reply to personal e-mail.





.

 

[Louie]

Fred,
I am having a problem with getting the combo box to show
the CircuitID it is blank.
I used the wizard to creat the Combo Box and it show the
data but when i run the form it is blank.
Lou