Here is another question. Is there a reason there is a certain "lag" in updating a field after a sum calculation?
The setup I have is with multiple fields.
A B C D CHK
A1 B1 C1 D1 CHK1
A3 B3 C3 D3 CHK2
and so forth.
The first fields or "A" fields is based on the sum total of the other fields.
The CHK fields are check boxes, with a value of "n" when the box is checked and a value of "0" when the check box is not checked
A = B+C+D+CHK
The itch is that field A does not properly execute.
For instance check box = 2
A = 1+1+1+2
A should equal 5
instead it totals 3 ignoring the CHK field until I put a value into second set of fields.
B1 = 2 etc. THEN field A calculates properly
This also includes when you check or uncheck the box
George Kaiser