can't set value to 0

[amna77]

hi I have one field on my form, which just calculte the total, like Total=sum(([Damage])+([Burn])+([Paint])) . now when i click on add new record, all forms clears up, but this total field does not. in there value stays the same. any help, how to do clear that.
i try to put codes on the add new button.
like Me.Total.Value = 0, but keep me error message that can't assiagn a value to this object.
Please help. thanks

 

[smozgur]

Hi amna77,

Try NOT using SUM function.

=[Damage]+[Burn]+[Paint]

I hope it helps.
Suat

 

[amna77]

Thank you very much, you saved my life, its working fine now, I tried so many things, but could not get 0 in the total field. Thanks smozgur, its working now becasue of you.

 

[smozgur]

You're welcome, amna77!

Suat