Still stuck: rerunning a query to change criteria

[Mafukufuku]

My form lets one set criteria for a query, from which some textboxes display
several Dcounts of the selected clients (grouped and counted by age and
gender). Now I need this query to be rerun once different criteria are set.
But I believe that as long as the form is open, the query wil be run ones and
then never again!

I could of course have people close and open the form again and again, but
that is cumbersome.

Me next try would be to have the criteria be set i the form and then as next
step run and open the query, including the data to be displayed in a subform.

But is there a command or event procedure I can use on a button? I tried
"Refresh"from the wizard but apparantly the wizard wasnt keen on refreshening
as the error was that the "refresh"command was not available.

So I am looking for either confirmation that my subform plan might work, or
a tip how to have the whole query rerun and data re-displayed once a
"Calculate" button of sorts is pushed. " On click: rerun qryhealthissues" or
something.

thanks

 

[Tom van Stiphout]

On Tue, 30 Mar 2010 02:55:01 -0700, Mafukufuku

Check out the Requery action.

-Tom.
Microsoft Access MVP