causeidm

Ok, I have a text box that is populated by the total on a sub form, then I have another text box that is populated by the difference of the total amount less the amount from another text box. that all works perfectly. what isn't working is I have a label that is suppose to set to visible or invisible based on whether the difference is positive or negative. the code works great, i set it to run on focus, so when i click on it, works like a charm. But what I can't do is get it to run when the text box value changes. I tried on change and after update, but that only seems to work if I changed the value in the text box, since this is all automated, i need it to change on it's own. how do i do this?