Subreports recordsource

[jj22171]

I have one main report with 3 subreports using the same recordsource (say, qry_Source). Each time a subreport is opened, the recordsource is re-queried. Question: Is there a way to requery the recordsource only once instead of 3 times? Thanks a lot.

jj

 

[genomon]

Each subreport will requery each time it is opened.
Possibly you could eliminate the subs & use grouping instead?

"Don't be irreplaceable. If you can't be replaced, you can't be promoted."

 

[dhookom]

If your issue is responding to multiple parameter prompts then you should read why you shouldn't be using them at faq701-6763.

Duane
Hook'D on Access
MS Access MVP