Forms valadation rule for calculated fields?

[Guest]

For an aircraft loading form I have a field that calculates gross weight as
items are added. I have specified a maximum value for the calculated field
but the valadation rule is not enforced.

 

[Rick Brandt]

For an aircraft loading form I have a field that calculates gross weight as
items are added. I have specified a maximum value for the calculated field
but the valadation rule is not enforced.

Validation rules (on a field or control) are only enforced when data is manually
entered into the field/control. It cannot enforce calculations or values that
are inserted programmatically. Use a different event (Form BeforeUpdate
perhaps) to perform the calculation separately and Cancel the update if it
violates your rule.