Combo box in a query?

[Craig Cerff]

How do I put a list box or combo box in a query? i.e.
when running a parameter query the parameter must come up
as a list box?

 

[John Vinson]

How do I put a list box or combo box in a query? i.e.
when running a parameter query the parameter must come up
as a list box?

Use

=[Forms]![NameOfTheForm]![NameOfTheControl]

as your criterion. The form must be open at the time the query is run;
it's convenient to create an unbound Form with unbound Controls for
this purpose, and put a command button on it to open a Form (for
onscreen viewing) or Report (for printing) based on the query. As a
rule it's best not to let users see query datasheets; if you want to
do so anyway, just have the button open the Query.