How to make a query run after changing criteria from a form??

[Rocky]

Issue: Can't get a responce from a query.
Have a form to create records in a table.
Using a parameter query to return results to a custom Dialog Box.
Custom Dialog Box has 12 combo boxes to reset criteria in the query which
returns two fields in the table to a subform in the Custom Dialog Box.
How do I make the query run and run again after changing the criteria?

 

[John Vinson]

Issue: Can't get a responce from a query.
Have a form to create records in a table.
Using a parameter query to return results to a custom Dialog Box.
Custom Dialog Box has 12 combo boxes to reset criteria in the query which
returns two fields in the table to a subform in the Custom Dialog Box.
How do I make the query run and run again after changing the criteria?

What kind of query? An Action query (Update, Append, Delete,
MakeTable)? or just a query returning records?

If the former, put a button on the Form to launch it.

If the latter, don't "run" the query AT ALL; instead, base a Form on
it for onscreen viewing, and/or a Report for printing, and put a
buttonon the form to launch them.

John W. Vinson[MVP]