468,272 Members | 2,035 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,272 developers. It's quick & easy.

Grouped Report With Subreport

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

Nov 13 '05 #1
1 1800
Melissa wrote:
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.

--
Marsh
MVP [MS Access]
Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

6 posts views Thread by David B | last post: by
1 post views Thread by last Name | last post: by
7 posts views Thread by Ellen Manning | last post: by
3 posts views Thread by kenneth xg | last post: by
reply views Thread by NPC403 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.