If then

C

CAKDH

i have a calculated field that is optional with a check box above. can i
have an if the check box is yes then do the calculation if the check box is
no then value is 0.00? what would be the expression?
 
D

Dirk Goldgar

CAKDH said:
i have a calculated field that is optional with a check box above. can i
have an if the check box is yes then do the calculation if the check box
is
no then value is 0.00? what would be the expression?
Click to expand...


Something like

=IIf([chkYourCheckBox], <your calculation here>, 0)
 
R

Ron2006

You will need to put that code in the OnCurrent event of the form and
in the afterupdate event of the checkbox.

Ron
 
Top