Combo Box for Query criteria...

[Edgarr8]

Hello!

I have a query in which i have about 200 customers and a couple of other details,
I would like to get a combo box or something similar to pop up when i run my query to allow the selection of a customer..

any suggestions and ideas will be greatly appreciated.


Thank you,

 

[Kryst51]

This would best be done in a form, where the criteria for the customerID is retrieved from the combo box on a form.

If you want to use a query however (which IMHO should be avoided) you can put in the criteria [Customer?] then this will send a prompt for you to type the name, but you can't do a combo box from a query, Only from a form.

 

[Edgarr8]

Thank you very much,

Well i wanted to do it in a query, because i can export to excel, where we need..but i will do it on a form, thank you,

 

[Kryst51]

Thank you very much,

Well i wanted to do it in a query, because i can export to excel, where we need..but i will do it on a form, thank you,

You can display the results in a query, just use the form to enter the criteria you want.