Make one field NZ when data is entered in another

Z

zenmytao1

I've created a form in which one field [Labor Cost 60%] automatically
calculates 60% of the Contract cost field. However, I have a field titled
[Labor Cost Known]; If I enter data in that field, I would like the [Labor
Cost 60%] field to be automatically 0.
 
O

Ofer Cohen

In the control source of the [Labor Cost 60%] field you can write

=IIf([Labor Cost Known]>0 and [Labor Cost Known] Is Not Null,0,[Contract
cost]*.60)

The Labor Cost 60% is a calculated field, and I hope you are not storing it
value in a table.
 
Top