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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|