Reset Field value

[Jono]

I have a field that normally shows the sum of a couple of other fields. I
also have a check box that when TRUE sets that field's value to "0"
overriding the formula's sum.

If the checkbox was selected in error and I uncheck it the original sum does
not return. How do I get it to return?

 

[S.Y.M. Wong-A-Ton]

If you're using rules, add a rule on the checkbox to set the sum field, but
then add a condition on the rule so that it will only fire when the value of
the checkbox is FALSE.

 

[Jono]

O.K. if I understood you, I had a rule on the checkbox that when selected
(TRUE)set the value of the sum field to "0". I added another rule to the
checkbox that when the checkbox is not selected (FALSE) runs the sum formula.

What happens now is that if I put values in the fields that are summed the
sum field shows nothing. If I then select the checkbox the sum field displays
"0". If I then deselect the checkbox the the sum field displays the result of
the formula.

How do I get the sum field to display the result of the formula without any
action on the checkbox?

 

[Jono]

Never mind. I put the formula back into the sum field. No when the form opens
the sum field runs it's formula then if the checkbox is selected it sets the
value to "0" then if unchecked it runs a copy of the sum formula.

Thanks for your help.