List Box in a Query

[Guest]

Is it possible to have a query parameter display a Table List Box (I have 18
Items in the table and they need to be spelled correctly to perform a proper
query), so that you can scroll down to the exact item you need when you are
running a report. Or is ther a better way to accomplish this?

 

[Guest]

i am a bit confused.
Do you want to use the values in your table field. 18 values in 18 different
records to enable you to filter your report result. meaning, when you choose
a value out of this 18 values, you will see the report related to one of them?

 

[Douglas J Steele]

Assuming that you're saying you want to select a query parameter from the
list of 18 possibilities, the answer is to create a form that has a list box
(or combo box) on it, and have the query use that control as its parameter.

If you want to allow the user to select more than one entry at a time from
the list box, see http://www.mvps.org/access/forms/frm0007.htm at "The
Access Web"