Querys will drop down list

  • Thread starter Thread starter Tracey McMillan
  • Start date Start date
T

Tracey McMillan

I am trying to create a query with a drop down arrow, can
this be done and if so how?
 
I am trying to create a query with a drop down arrow, can
this be done and if so how?

Yes. Create a small unbound Form, let's call it frmCrit. Put a Combo
Box control on it, using the allowed values for the search criterion
as its rowsource - let's call it cboName. The bound column of cboName
should be the value (such as a numeric ID) that you want to search.

Then use a criterion in your Query of

=[Forms]![frmCrit]![cboName]

It's convenient to put a command button on frmCrit to open a Form (for
onscreen display) or Report (for printing) based on the query; you
don't need to open the query datasheet at all.
 
Back
Top