Trouble assigning report to variable

[Mugs321]

Hello,
This should be an easy question but I cannot figure it out.

I have a Report named "missingReport". The query I want to use for the RecordSource is quite complicated and so I need to set it dynamically. When I click a button in my form, I want to set the RecordSource to mentioned query. Here's the problem (taken from the button's code):

Dim misRep As Report
Set misRep = Reports![missingReport]
.
.
.

The 'Set' statement above returns "error code 438: Object doesn't support this property or method".

I can do this no problem with a form (ie Forms![missingForm] but I cannot get around the Report problem.

Any ideas?

 

[Crowley16]

firstly, why not encapsulate the complications in a single query, and then set the recordsource to that query?

when you run this code from the form, the report itself isn't loaded, therefore you cannot assign it to a report object.

you can load the report first, or do this in the report_open event

--------------------
Procrastinate Now!

 

[Mugs321]

The query, written in SQL, contains data chosen from a comboBox. How do I include dynamic data if the query is written in 'SQL View'?

I've already tried added the needed code to the report_open Sub. The code wasn't being run when I opened the report. I even put a Debug 'Stop' in the report_open and the program didn't stop.

 

[Mugs321]

I figured out how to include the comboBox data in the query. Thanks for your help.