how to use combo box to set criteria for query

[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?

 

[Jeff Boyce]

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>