1 Report with multiple queries

[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

 

[Allen Browne]

Report_Open is the only event you have.

(Reports don't have Load or Current events.)

 

[Roger Carlson]

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.

 

[Al Camp]

Allen,
Thanks for that information. I appreciate it.
I think this is a great example of one of my "senior moments".
Doh!!
Al Camp