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

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
