Printing Reports And Subreports

[FontanaS]

Hello,

I have a report that is generated using a recordsource in visual basic. In that report I also have three subreports that use a recordsource in visual basic. The probelm is that I open the parent report in acPreview mode. I can see the results of the three subreports just fine. When I select the print icon on the toolbar, the subreports DO NOT print, just the parent report.

This seems so odd to me. Is there a reason for this?

THANKS

 

[dhookom]

How are you using visual basic (or VBA) to generate the record source?
Have you tried setting the SQL of the record source query prior to opening the reports?

Duane
MS Access MVP