Grouped Report With Subreport

[Melissa]

Can anyone help me with this ---

I have a grouped report with a subreport in the group footer and the report
starts a new page for each group. The subreport is based on a query which
has criteria in one of the fields. I have a function in a standard module
where the value of the function is part of the criteria. For each group, I
need to run the
function and have the query requery so the subreport prints
the correct records. Where do I call the function and how do I get the query
to requery so the subreport prints the correct records?

Thanks for any help you can give!!

Melissa

 

[Marshall Barton]

I have a grouped report with a subreport in the group footer and the report
starts a new page for each group. The subreport is based on a query which
has criteria in one of the fields. I have a function in a standard module
where the value of the function is part of the criteria. For each group, I
need to run the
function and have the query requery so the subreport prints
the correct records. Where do I call the function and how do I get the query
to requery so the subreport prints the correct records?

You can not change a (sub)report's record source once the
reports have started.

If the function's argments are based on fields in the main
report's record source table/query, then you can call it
from a main report text box expression in the group footer
and use that text box as a Link Master field for the
subreport.