Drop Down Box / Selection

T

Tedd

I have a query that asks the user to enter a code. In my
query I use something like "=[Code?]" in the criteria of
the Code column. So when they run the query a message box
comes up and asks them to enter a code and it finds the
code that's equal to what they entered.

I was thinking that a drop down box (or something like it)
would be nice so that the user could select which code
they wanted.

Can this be done?

Thanks
 
T

tina

not from within the query itself.
you can put a combo box on a form. set the combo box's RowSource to whatever
table/query/SQL statement will give you the list of codes you want the user
to choose from.
set your query's criteria to

Forms!MyFormName!MyComboBoxName

hth
 
Top