I'm not sure it matters that your report is within a form, I'm talking about my report/subreport staying open too. User clicks on options in the report, subreport responds appropriately. My code looks like:
Code:
Select Case Me.FraSort
Case 2
Me.BreakDownSheet.Report.GroupLevel(0).ControlSource = "SomeField"
Me.BreakDownSheet.Report.GroupLevel(1).ControlSource = "Car_No"
Case Else
Me.BreakDownSheet.Report.GroupLevel(0).ControlSource = "DifferentField"
Me.BreakDownSheet.Report.GroupLevel(1).ControlSource = "Car_No"
End Select