Generating Subreports with VBA

[speedymercial]

How can I generate subreports using only VBA. I have a report created with VBA, including several controls and the recordsource-SQL.
All within a "sub"-procedure. No I want to create subreports within this main report and - if possible - within the same procedure.

Any Ideas

Best regards

 

[KenReay]

Hi

Before I proceed, let me say I have not done this before, but..

I would think you create the (sub) report itself, using CreateReport (presuambly as you have done for the main report, since fundamentally there is not difference between a report and a sub report, it is simply the fact that it is contained within asubreport control, which make a report into a (sub)report. Then on thae main report, cerate a subreprot control using CreateReportControl, with control type acSubform (since there does not seem to be an acSubReport constant) and set the sourceobject proeprty of the subreport control you have just cretaed, to the relevant (sub)reportname

Hope that helps Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
UK
kenneth.reaySPAMNOT@talk21.com
remove SPAMNOT to use