Parameter queries provide a means to make queries more flexible by allowing criteria to be specified when the query is run (or a report or form based on the parameter query is run.)

Unfortunately, when the query requires multiple criteria, Access displays message boxes requesting each criteria, one at a time, something most users would find very tedious, not to mention amateurish.

The attached database demonstrates how to use a form to collect the criteria and set them up in the parameter query and then generate a form that uses the query as its data source. This methodology enables you to use comboboxes (as in the demo) to display valid choices (something the standard parameter query does not make possible)

Glenn