Opening report based on drop down selection

[bishman]

Hi

Here's some Access VBA:

Dim found As Boolean
Dim frm As Form

found = False
For Each frm In Forms
        If frm.Name = "SelectType" Then
            found = True
        End If
Next
    
strReportType = Forms!SelectType!ReportTypeCombo.Value

Now depending on what has been chosen in the drop down list (ReportTypeCombo), how would I go about opening certain (already existing) reports?

TIA,
Bishman

 

[dhookom]

Are you finding a report type (don't know what this means) or a report name? If this is a report name from the combo box, you could use code like:

DoCmd.OpenReport strReportType, acViewPreview

Duane
MS Access MVP

 

[bishman]

Yes, that's exactly it...thanks so much.