I have some check boxes that show/hide different subforms. Each subform has multiple Quantity fields for entry. I need to make it so when a quantity is entered into any of the fields in a particular subform, that the checkbox that controls that subform gets hidden. This is so that subform can't be closed when there is any data input into any quantity field.
I have this script so far as a Validation. I am using it on a subtotal field.
if (DistSubTotal.rawValue == false)
CtrlBlock.DistributionCheckbox.presence = "visible";
else
CtrlBlock.DistributionCheckbox.presence = "hidden"
It does what I need, but, every time anything is entered into a quantity field, I get a validation error that says "DistSubTotal validate failed." Should it not be a Validation? It doesn't work as a Change at all.
Thanks
George Kaiser