1 Report with multiple queries

  • Thread starter Thread starter Al Camp
  • Start date Start date
A

Al Camp

I'd like to use one report design , but change the query
behind the report "on the fly". I know that will involve
changing the RecordSource query "programmatically".

What event on the Report should I use to populate the
RecordSource... Load? Open? Current?

Thanks in advance,
Al Camp
 
Report_Open is the only event you have.

(Reports don't have Load or Current events.)
 
I generally do it from outside of the report. Base the report on a saved
query and then modify this query before you open the report.

On my website (see sig below) is small sample database that illustrates how
to do this. It's called "CreateQueries2.mdb" Look at Form 5: Changes the
criteria for a report.
 
Allen,
Thanks for that information. I appreciate it.
I think this is a great example of one of my "senior moments".
Doh!!
Al Camp
 
Back
Top