Selecting from a list

[Guest]

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

 

[Guest]

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.

 

[ajetrumpet]

I suggest making a form and linking your query to the combo box you place there. You can prompt the query whenever you want using the combo properties options (on click might be good). Thus, you can have the user look up in the combo box the value they want so they don't have to memorize.

If you want to use a QUERY for selecting certain records by way of user input, you're going to have to have a parameter prompt.