Not seeing a form in a report

N

No Go

Can some assist me....
I have three forms that I want to list in the details section of a report.
Dilemma: How do I get each form to start on a new page and how do I get the
report to print only the forms that have data in them, ignoring the ones
that don't have any?
Cheers
John
 
L

Larry Linson

You can embed a Form in a Subreport Control. I don't recommend it, though,
as I think you'd be better off creating a corresponding Report to embed in
the Subreport Control. Generally, the easiest and best approach to
coordinating data in a main Report and its Subreports is via the
LinkMasterFields and LinkChildFields properties of the Subreport Control.

If there is some reason that approach will not work, post some details here
to clarify, and perhaps someone will be able to help.

Larry Linson
Microsoft Access MVP
 
J

John T

Thank you for that.....
I have now changed all forms to reports.....These reports (5 of them) are
now in one report. Effectively they are subreports. I would like to print
each subreport but have it so that they each start a new page and if one
doesn't have data in it, then not print at all and not leave a blank page in
its place. Each report is linked to a code which is reference to an open
form. I have forced a page before the section in the individual reports but
they wont do that when they are acting as subreports.
Any help would be appreciated.

Cheers
John
 
Top