Select particular subreport

[xlStar]

I am (trying) to design one Main Report with a sub-report containing Financial Information.

However, there are 6 different Financial Information subreports and only one is required.

How do I get the Main Report to select one particular subreport?

The Main Report included a UnBound subreport called subReport2, I am trying to use the Main Report's On Open event procedure to 'control' the "Source Object" on subReport2 but no joy.

Is there a way?

 

[sxschech]

There may be a way, but one alternative is to have all the subreports on the main report and then use vba to make the particular subreport you would like to display visible and the others not visible.

Me.SubRep1.Visible = False
Me.SubRep2.Visible = True

Are the formats of the subreports the same? Same cols layout etc. Then you could change the query record source rather than the report record source and then you would only need one subreport and have that subreport's record source be changed.

 

[xlStar]

Thank you.

I've managed to work it out by...

Me.subReport2.SourceObject = "subR2