Create a subform using CreateReportControl

[MrMajik]

I need to create a subform using CreateReportControl

I have the code working that creates a report on the fly using CreateReportControl but now I realize I need to access two tables to populate the report. Does anyone have experience doing this?

Thank you.

 

[MrMajik]

Clarification: My first post says, "I need to create a subform using CreateReportControl"

It sould read, "I need to create a subreport using CreateReportControl"

I apoligize for any confusion this may have caused.

MrMajik

 

[MrMajik]

I found the solution and for the record here it is:
I created a report and subreport using the report wizard. Then I veiwed the Properties of the newly created report and went to Data | Record Source and copied the SQL string to the

myReport.RecordSource = &quot;<insert copied sql string here>&quot;

line of VB code. It works just as slick as you will

MrMajik