#Error Message in Form

[rogerarce]

I have a query that creates a table. I have a subform linked to this table. The form where I have this subform
has a sum field. The problem is that when this subform does
not have information and does not display any value or
field, I get a #error message where I needed to be a zero value at least. This is the code I have in the sum field:
=Sum(nz([Amountowned],0)).
I hope you understand my question.

Thanks in advanced.

Roger

 

[Rolliee]

I would set the field using an event - say on update of the critical value. The write code that says

me.[SumField] = SUM(.......)

Rollie E