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.
