Error# on no data in subform

[Tash]

Hello -

I'm sure this is a simple problem, but I just can't seem to get it to work. I have a simple invoice report that I have put a subform into. I total the subform and then reference that total field on the main report. It works great when there is data, but if there is no data in the subform, I get the Error# message on the Invoice totals. I've included the nz([total]) function on all my calculations, but I still get the error message.

Thanks!

 

[Tash]

I figured it out - I used the report.hasdata=true function and it works perfectly. Thanks anyway!