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

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?

On Thu, 2 Feb 2006 14:46:29 -0800, "Rocky"
wrote:

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]