Using Drop down box within queries

C

Carol

Can a drop-down box/list be used with a query?

For example, I have a query that asks for a specific section. I'd like to
be able to use a drop down to show the available sections. (I have this on a
form).

Thanks,
Carol
 
D

Douglas J. Steele

You can have the form refer to the combo box on your form.

To do this, put Forms!NameOfForm!NameOfCombobox as the criteria in your
query. (replace NameOfForm and NameOfCombobox with the appropriate...)

The form must be open for this to work: running the query when the form is
not open will simply prompt you for the value.
 
Top