requerying

[Guest]

Can I use "requery" in VB to run a query without having to open the query? I
have tried through the help to understand this command but I am not clear. My
situation is that I have a report that provides summary data on multiple
characteristics of a given identifer (say soil type). Each characteristic is
summarized on the report in its own subreport, which is itself based on a
"sub"query ( this is necessary due to various calculations within each
query). What I would like to do is rerun each query underlying the subreports
each time a different soil type is chosen. I can do this in VB by using the
"OpenQuery" function on each query, but that results in 10 to 15 queries
being opened in the database, and quite a visual mess. If not the requery
function, is there a way to run, or "updating", the queries without opening
them ??

 

[John Vinson]

Can I use "requery" in VB to run a query without having to open the query? I
have tried through the help to understand this command but I am not clear. My
situation is that I have a report that provides summary data on multiple
characteristics of a given identifer (say soil type). Each characteristic is
summarized on the report in its own subreport, which is itself based on a
"sub"query ( this is necessary due to various calculations within each
query). What I would like to do is rerun each query underlying the subreports
each time a different soil type is chosen. I can do this in VB by using the
"OpenQuery" function on each query, but that results in 10 to 15 queries
being opened in the database, and quite a visual mess. If not the requery
function, is there a way to run, or "updating", the queries without opening
them ??

Ummm...

If the Report is based on a query which includes these subqueries,
simply open the Report.

It is not necessary to open or run any of the subqueries in their
stand-alone state. Opening the report will run all of them.

You're making this much harder than it really is!

John W. Vinson[MVP]

 

[Guest]

Oh... yeah, I can sometimes do that. I will try that and see how it works.
Thanx.