A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Using Forms
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Still stuck: rerunning a query to change criteria



 
 
Thread Tools Display Modes
  #1  
Old March 30th, 2010, 10:55 AM posted to microsoft.public.access.forms
Mafukufuku
external usenet poster
 
Posts: 21
Default Still stuck: rerunning a query to change criteria

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
  #2  
Old March 30th, 2010, 11:57 AM posted to microsoft.public.access.forms
Tom van Stiphout[_2_]
external usenet poster
 
Posts: 1,653
Default Still stuck: rerunning a query to change criteria

On Tue, 30 Mar 2010 02:55:01 -0700, Mafukufuku
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

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 05:22 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.