I am having difficulty getting a statement to work. Basically I want to
have field 1 take "x" value and then return an "x" value in Field 2. 3
options for field 1 that returns the value of that option into field 2.
This is what I have that returns errors:If (Field 1 eq "A") then (Field
2 eq "10")elseifIf (Field 1 eq "B") then (Field 2 eq "8")elseifIf (Field
1 eq "C") then (Field 2 eq "6")endifCan someone help me with the correct
syntax to perform this operation? I am sure I have something wrong
I have multiple number fields that perform calculations based on GPA,
Credits, Quality Points etc.. the last two fields divide previous
returned values but when the form opens I get the overflow error. How do
you surround the calculation with a check to assure the variables are
non zero, non-null?How can you prevent the fields from trying to
calculate until the form is loaded?Any help is greatly appreciated.
I get the overflow error when my form opens ( I know it is cuased by two
division fields at the end of my form). I have mutlple fields that do
computations based on other fields. How do I set a default value for a
number field? How can you establish a variable that isn't set until the
end of the load process.. how would you do that for a field?
I have the same issue that involves two fields that are performing a
division calculation based on other fields that are calculating. I get
the overflow error when the form opens. How do I set a default value for
a number field? You also mentioned that you could establish a variable
that isn't set until the end of the load process.. how would you do that
for a field?