This is a continuation from a thread I started about a month ago... but never got a chance to resolve (I had bigger issues at the time...hehe)
In my Issue Tracking database, I would like to print a summary report of the "Issue." On my main Issues Form... depending on the Issue Type selected a different subform is inserted by setting the SourceObject property using a SELECT CASE statement. I would have liked to do the same thing on my Report... but it appears that this ability(Source Object) is not allowed on Reports... any comments?
I am now trying to implement solution 2... setting the Visible Property of my Subreport_Controls. In this case I will place ALL of my Subreports on the same Issue Report and try to control which one is visible. This is the code I am trying to use, any suggestions? What Event should I try? (On the main Report I have tried "On Open", "On Activate" and in the Detail Section of the Report I have tried "On Format" and "On Print")
SELECT CASE [Issue_Type]
Case Me.Issue_Type = "Issue1"
Me.Subreport_Control_Issue1.Report.Visible = True
Me.Subreport_Control_Issue2.Report.Visible = False
Case Me.Issue_Type = "Issue2"
Me.Subreport_Control_Issue2.Report.Visible = True
Me.Subreport_Control_Issue1.Report.Visible = False
In my actual code I will have about 12 of these layered Subreports. Thanks for any suggestions... Im open to anything at this point.