Combo box in a query?

  • Thread starter Thread starter Craig Cerff
  • Start date Start date
C

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?
 
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?
Click to expand...

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.
 
Back
Top