Hide Subreport if specific fields are empty

[hawkins]

I have a subreport based on a query that contains specific fields from the tables. I would like to be able to hide this subreport if the specific fields are empty. The whole record may not be empty so it needs to become invisibile if only the specific fields are empty. Do you have any suggestions on how to do this?

[June7]

What you need to do is hide the subreport container control. So in the Detail section Format event of the main report, something like:

Me.subreportcontainername.Visible = IsNull(Me.subreportcontainername!fieldname)

I always give the subform/subreport container control a name different from the object it holds.