Drop Down Box / Selection

  • Thread starter Thread starter Tedd
  • Start date Start date
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
 
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
 
Back
Top