Setting SourceObject for a subReport

[Guest]

I have a Report with series of subReports. I want to change the
"SourceObject" of the subReports based upon a value on the main report. On
the Report's detail section (where the subReport reside), on the event
"Print" I wrote the following code.

If Me.TrafficCount > 0 then
Reports!ReportName!subReportName.SourceObject = "subReportOne"
Else
Reports!ReportName!subReportName.SourceObject = "subReportTwo"
End If

I must be missing the proper syntax to accomplish this task. If there is a
TrafficCount I want to print one subReport if the count is "0" I want to
print a different subReport.

Any help would be greatly appreciated. THANK!

 

[Guest]

I don't think you can do this in the OnPrint event. You'll have to do it in
the OnOpen event.

Barry

 

[Guest]

I will try by moving it to the OnOpen Event this evening when I am back at
the jobsite. So, you think the syntax is correct, only the Event was wrong?

 

[Guest]

Yes. The syntax looks correct. As you say, it's just the order of events
that's tripping you up.

Barry