MLNAUMANN
Member Since: 1998/07/28
Tech Certifications:

Provide a quick, creative biography in 140 characters or less.

More bio
Activity
Points this month0
Total points260
Questions: 1
Solutions: 2
Articles:
Videos:
Courses:
Posts:
Professional Background
No Professional Background shown
More
Education
No Education Background shown
More
Full Biography

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]![ReportLevel]
Select Case ReportLevel
    Case "1"
          Me.RecordSource = "Query1"
    Case "2"
          Me.RecordSource = "Query2"
    Case Else
          MsgBox "Error Query not Not Found"
End Select

End Sub

More
Languages
No Languages shown

Level Progress

Current: Level 0
MLNAUMANN needs 1,740 points to level up.
LVL 1
  • Overall
    0