If the report uses different queries which I suspect you would create the report with an unbound record source. Then when you open the report it would refer to the MainForm to see which query it should use.
Private Sub Report_Open(Cancel As Integer)
ReportLevel = Forms![MainForm]![ReportLe
Select Case ReportLevel
Me.RecordSource = "Query1"
Me.RecordSource = "Query2"
MsgBox "Error Query not Not Found"