popup box

[wfarmer]

can i create a form to be able to enter all criteria
before running a query..(ex. begin date, end date, product
number) without having several popup boxes?

 

[Joan Wild]

Sure. Just create an unbound form and put as many controls (textboxes,
combo boxes, etc) as you need.

Be sure to give the controls some meaningful name (makes it easier).

In your query's criteria you can refer to the controls on the form. The
form must be open in order for the query to read it. You could add a button
to your form to run the query or better, open a report based on your query.

The criteria row would reference the controls by
Forms!frmCriteria!txtBeginDate

Substitute the name of your form for frmCriteria, and the name of your
control for txtBeginDate.