Subreport Problem.

[cfuser10]

Hello,
I would like to create a report that has a subreport. I would like to use two parameter crosstab queries - 1 for the main report and a 2nd one for the subreport.

First, when I tried to insert a subreport control into the main report the crosstab query fields would not show up in the wizard. I then created a separate report using the 2nd crosstab query. I inserted the second report into the main report.

When I first tried to run the report, I got a pass-through query error. I found a microsoft KB article that had a suggested work around - on the main form_Onload property I inserted the following code:

Private Sub Report_Load()
Me!rptDeptEvalSubReport.Report.RecordSource= "qryDeptEvalSubQuery"

End Sub

Now,when I run the report, the main report will run, but I get the following error relating to the subreport:

Object doesn't support this property or method.

I'm not sure how to approach this.

Thank you for any suggestions.

 

[cfuser10]

I solved my problem.

Thanks.