M
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
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