Fill textbox based on another field

[dmyoungsal]

I have a textbox (HrRate) that defaults to $100.

I want this field to change to $75 if a check box (salesdel) is "T". I am trying to use an Iif statement like "=Iif([salesdel]="T", 75,100), but the showing default value does not change. What am I missing?

 

[pbaldy]

If it's a checkbox try -1 instead of "t".

 

[dmyoungsal]

What.does false equal (for curiosity sake)

 

[pbaldy]

Access stores true as -1 and false as 0 (for a yes/no field that is).

 

[dmyoungsal]

Thank you!

 

[pbaldy]

Happy to help!