Using Drop down box within queries

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Limit to Records in a drop down box? 2
Form and lost drop down list 1
Macro Results, How to filter? 1
combo box locked 4
Problems with drop down boxes. 5
add a choice to a drop-down box 7
Can't drag in drop to create a query 0
Do I need to reinstall Ms Access 2003? 6

Back
Top