Make one field NZ when data is entered in another

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
Back
Top