List Box in a query

[matt]

hello all,

i have created a query with "supplier name" as one of the
fields. As a criteria for this field, i have put [enter
supplier name]. so the user is prompted for the name of
the supplier when the query is run. is there any way that
a list box could show as the parameter and allow the user
to just select the supplier rather than type it? If not,
are there any other options other than having the user
type in the parameter? any help would be greatly
appreciated. thanks, matt.

 

[Michael]

I had this sort of problem.

Try the solution posted in an answer to pcap on 3jul by
John Vinson. It worked for me