Text box question

[north-bc]

Just a quick question for the guru's out there. I have 2 text boxes on a form and I need the second one to display 0 if the first text box - 5 is less than 0.

1st text box's (Inf_Percent) control source is: =((([Total_Pts]/2)/Forms!frmLoad!Total_pcs)*100) --this gives me a percent.

2nd text box (Inf_tol) needs to subtract 5 from the 1st text box's value and display 0 if it is less than 0.

Not sure where to do this (control source?) and how to do this as well.

Any help is appreciated.

Thanks in advance,
Todd

 

[BLeslie88]

here ya go

=IIf([txtBox1]-5<0,0,[txtBox1]-5)

 

[north-bc]

Thanks for your help

N/t

 

[fuel52]

Then how do you get the number from the second text box into the table if =IIf([txtBox1]-5<0,0,[txtBox1]-5) is in your control source already?