Setting a Report Variable with a string

[Paul H]

Before I open a report I want to run the record source query to see how many records are in it. How do I set the value of my report variable based solely on the name of the report selected on my form? This does not work. Error 424 - Object Required

dim rptName As Report
set rptName = "Reports!" & Me.cboReport.Column(2)
qryName = rptName.RecordSource

Any suggestions?

[June7]

qryName = Reports(rptName).RecordSource

However, report must be open in order to reference its RecordSource property.

[Paul H]

Thanks June,

This is what I came up with.

        
        rptName = Me.cboReport.Column(2)
        DoCmd.OpenReport rptName, acViewDesign
        Reports(rptName).Visible = False
        qryName = Reports(rptName).RecordSource
        
        DoCmd.Close acReport, rptName, acSaveNo