Subreport not displayed in parent Preview or Print

[Michelle]

I have an Access 2000 report with several subreports which have their
own queries. All of the subreports display when I preview or print the
parent report, except one. It is set as Visible with CanShrink set to
No. If I preview the sub report on it's own all is displayed (data is
present), but it won't show when I preview or print the parent report.


Has anyone encountered this issue before? Any advice or suggestions
would be appreciated!


Thank you,
Michelle

 

[Allen Browne]

Chances are the subreport is incorrectly linked to the main report.

Open the main report in design view.
Right-click the edge of the subreport control, and choose Properties.
On the Data tab, what is in LinkMasterFields and LinkChildFields?

Access will choose the subreport records based on matching these fields. If
the properties are set wrongly, no records will match, and so the subreport
won't show anything.

 

[Michelle]

Thank you for your reply,

Fortunately I have solved the issue - two of the sub reports were
pointing to the same query - i changed one of them to point to
something else and that seemed to force both sub reports to appear when
previewing & printing from the VB application (tho they are still not
showing in layout preview).

Thanks,
Michelle