Recordsource of report

[Guest_imported]

How do you set the recordsource of a report in VB? I tried to set the recordsource before the report is opened and get an error that says the report isn't open.

[Reports]![[RptContacts].Recordsource = "Select..."
DoCmd.OpenReport "RptContacts", acViewPreview

I tried to set the recordsource after the report is opened and get an error that you can't set the recordsource after printing has started.

DoCmd.OpenReport "RptContacts", acViewPreview
[Reports]![[RptContacts].Recordsource = "Select..."

What gives???? Is there a way to open the report without printing it, set the recordsource, and then print?

TIA!

 

[JohnLowell]

You need to set the recordsource in the On Open event of the report.
Set the recordsource like this:

Me.Recordsource = "Select..."


You still would open the report like this:

DoCmd.OpenReport "RptContacts", acViewPreview