subreport recordsource

[Guest]

Hi. I have a report that has a subreport which in turn has a subreport.

The recordsorce of the report is called from the report.onopen event as..
me.recordsource = "SELECT...."
The subreport's recordsource is called in the same way, however, when I try
to use it once again for the sub-sub report I get an error "Can't set the
record source property in print preview or after printing has started."

If I open the sub-sub report by itself...it works... but receive the error
when the main or sub report is opened.

Thanks

 

[Guest]

Hi Shelley,

What's stopping you from having your recordsource saved with your report
instead of setting it in the openreport event?

Damian.

 

[Guest]

I am upgrading from mdp to access project using sql backend and found it
easiest when asked to supply a variable from another form.

 

[Guest]

Fair enough... perhaps saving a record source with the report and applying a
filter on opening the report will work for you?

D.