edit query box

[garbett_d]

just something i was interested in and wonderd if any one knew?

i have created a query which filters my main data table by "part number" and then produces reports for all data associated with this part number (and suprisingly enough it actually works lol)!

But i was wondering when you use the query and the small box appears asking you if you to input your part number, is there a way that instead of having an input box you could change this to a drop down menu instead?

If any one has any ideas i would be interested to know?

cheers

 

[ColinEssex]

Assuming your query is attatched to a form, you can have a ComboBox to select then show the records using that selection.

Refer your query criteria to the ComboBox on the form instead of having [Enter part No] or whatever.

Col

 

[garbett_d]

thats it though i dont think the query runs from a form?

 

[Graham T]

garbett_d

It should be easy enough to create a form then use the form control as the criteria for the query.

See the simple attached example to give you an idea.

HTH

Graham