how to use combo box to set criteria for query

  • Thread starter Thread starter lonell
  • Start date Start date
L

lonell

how can i use a combo box to set the criteria for my query
instead of using the Like[Enter it here] function that
requires the user to enter the field to filter by and
leaves too much room for error?
 
Lonell

Create a form with the combo box based on your narrowed selection criterion.

Modify your query to include a reference to the combo box on the form as the
criterion -- something like:

Forms!YourFormName!YourComboBoxName

Modify the form to include a command button that runs the query.

Good luck

Jeff Boyce
<Access MVP>
 
Back
Top