I have a report that will have up to five different sub-reports. Only one of the sub-reports will be needed based on a field on the main report. That field name is "txtInterviewTypeID". I am trying to use the following code in the oncurrent event of the main report but it doesn't seem to be driving which sub-report to make display.
Note that I have the sub-reports on top of each other in the detail section of the main report if that matters.
If Me.txtInterviewTypeID = 1 Then
Me.TechInterviewQuestionnaire.SourceObject = "subrptInterview1"
If Me.txtInterviewTypeID = 2 Then
Me.TechInterviewQuestionnaire2.SourceObject = "subrptInterview2"
If Me.txtInterviewTypeID = 3 Then
Me.TechInterviewQuestionnaire3.SourceObject = "subrptInterview3"