Is there a way to choose 1 of 2 different subreports based on a field in the main report? For example, if Canadian Currency is checked off, a subreport where the calculations are done in Canadian dollars is printed along with the rest of the main report. If Canadian dollars is null, a different subreport is inserted into the main report.

Thanks.

Greig

Yes, on the main report's detail section's ON FORMAT event, you can put something like this:

If Me.chkCanada Then
    Me.srpMySubReport.SourceObject = "srpCanada"
Else
    Me.srpMySubReport.SourceObject = "srpUSA"
End If

I'm using fake names for the checkbox, subreport control, and subreport names. Use yours.


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division