Hiding multiple subreports

[JOY]

I have a report with several subreports. They all appear, even with no data.
I have tested this by setting a message box to say "i am empty" when i open a
subreport independently if it has no data. It does this, but still shows in
the main report. I've tried various logic statements with the HASDATA
property, but still no luck. Any suggestions?

 

[Bob Miller]

Then, is your problem that #Error is displayed? If it is then go here:
http://www.mvps.org/access/forms/frm0022.htm
This may guide you where you want to go.