Calculation result that makes a subform visible

[usuggestaname]

Hi - I have two fields that will have dollar amounts entered. If one of the fields is a higher dollar amount than the other field, a subform with a text field should open asking for an explanation. How would I do that? I don't have a great deal of coding knowledge. Thanks.

[whyisthisme]

in the exit event of the dollar amount field that if it is higher will show the subform put (in formcalc):

if ($ > NumericField1) then

yourSubform.presence = "visible"

else yourSubform.presence = "hidden"

endif

obviously changing the names of the fields to whatever you have called them.

[Vjay_Reddy]

Hi,

Keep the below script On calculate event of the subform under which these two fields are there language should be JavaScript.

yoursubform.presence = (firstNumericValue.rawValue < secondNumericValue.rawValue) ? "visible" : "hidden";

Vjay