queries with drop down box

[kabir_hussein]

hi

just wanted to ask does anyone know if there is a way of making a query where you can use a drop down box instead of typing in the search item

i have been trying to no avail

many thanks

 

[Mile-O]

You have to make a form with your combobox on it and reference that in the query like this:

[Forms]![MyForm]![MyCombo]

 

[kabir_hussein]

query for report

hi

thank you for your advice however i wanted a drop down box for a report, at present if i wanted to view a price for an item i have to type in the item in the msg box which i have created using a query

however i wanted to make life easier so i was hoping there is way of instead of typing in a price description i could simple use a drop down for all the items in the list which pops up with a msg box

thank you

 

[Mile-O]

No, you can't do that.

A combo box will have to go on a form. You can make a small form with it's PopUp and Modal properties set to Yes that has a combobox. And on a button on the form put some code to open the report you want, referening the form.