Prev: Change Currency Using a Form
Next: Calculated fields on a form
From: Mafukufuku on 30 Mar 2010 05:55
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
From: Tom van Stiphout on 30 Mar 2010 06:57
On Tue, 30 Mar 2010 02:55:01 -0700, Mafukufuku
<Mafukufuku(a)discussions.microsoft.com> wrote:

Check out the Requery action.

-Tom.
Microsoft Access MVP


>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
 | 
Pages: 1
Prev: Change Currency Using a Form
Next: Calculated fields on a form