Selecting from a list

S

Sunny

Hi,
I have a table with several fields and on of the field has a combo box.
I want to write a query such that the end user can select from one of the
value on the combo list.

I tried this
select * from table where field1 =[Enter Value];
This works, but the values in the field are too long for the end user to
memorize.

I want something like this:
select * from table where field1=(Select distinct field1); (shows the list
of options)
This syntax doesnot work, can someone suggest a solution.

Thanks
 
S

scubadiver

What are you trying to achieve?

Create a form with an unbound combo box and call it something relevant. In
the criteria row of the query create a filter that references your combo
option. Then you can create a button that opens the query, runs a report ...
or whatever you want to do.
 
Top