criteria

  • Thread starter Thread starter casey
  • Start date Start date
C

casey

I am not sure, but it seems like there has to be a way to
do this.

I want to be able to select from a drop down box to define
my query criteria for a names field.
 
You can't do this directly in a query.

Create an unbound form with a combobox on it, that lists the 'names'.

Then in your query, set the criteria to refer to this combobox.
i.e.
Forms!YourForm!NameofComboBox

The form must be open when the query runs. You can add a button to your
form to open the query, or better yet open a form/report based on your
query.
 
Back
Top