Manipulate report record source

[Jason]

I have one report that I would like to use to display several different
record sources (just filtering results). How do I code this manipulation on a
form used to open the report? I tried the code below but it gives me a
"Run-time error ' 2465': Application-defined or object-defined error"

Reports!rptOpenCARs.ControlSource = strSQL

 

[Allen Browne]

You can set the RecordSource of the report in its Open event.

You cannot do it from elsewhere, as the timing will be too late.

 

[Jason]

Is there a way I can pass a string or some information to the report from a
form to indicate which dataset I want the report to display?

 

[Allen Browne]

In Access 2002 or later, you can pass it in the OpenArgs of a form.

In earlier versions, you can create a public string variable, set it before
you OpenReport, and read and clear it in Report_Open.

If it is just a matter of specifying criteria, it may be possible just to
use the WhereCondition of OpenReport as in these examples:
http://allenbrowne.com/casu-15.html
http://allenbrowne.com/casu-08.html