Are you saying that you want to hide the subreport if it has no data? If so,
reports have a NoData property, so you can hide the subreport 'control', i.e.
the control in the parent report which houses the subreport, by putting code
in the Format event procedure of whichever section of the parent report
contains the subreport:

Me.MySubreportControl.Visible = Me.MySubreportControl.Report.HasData

Ken Sheridan
Stafford, England

"Chey" wrote:

So I took out all the labels
But I have a field that is invisable, then on top of that I have a formual.
Then I have a subreport that I have done the same with.
How do I get the subreport to do the same?
I don't want any blank pages.
Thanks