Assign the recordsource to report at runtime

[Tim]

Here is the code ...
strSQL = "SELECT tblStudents.StudID, tblStudents.SName WHERE
tblStudents.StudID= '" & glbStudID & "'
Set rst = MyDatabase.OpenRecordset(strSQL)

How can I assign a recordsource to my report, rptStudents at runtime? Note:
I cannot use Me!ReportName because this is a sub procedure. It's called by
another sub procedure. Thank you

 

[ruralguy via AccessMonster.com]

You can assign the RecordSource of a report in the Open event of the Report.