unbound text box running command

  • Thread starter Thread starter causeidm
  • Start date Start date
C

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?
 
Causeidm,

Would it serve your purpose to run the code on the After Update event of
the control on the subform, whose changed value results in the changed
main form total?

Another approach might be to change the disappearing label to a textbox
(that looks like a label :-) ), with it's control source as an
expression that produces th same result.

Another approach to consider would be Conditional Formatting.
 
I tried running it on after update, it doesn't run the code unless i click in
the text box and change the value.

The text box idea sounds good, I'm going to give that a try.
 
Text box worked like a charm, just set the control to an iif statement,
tahnks alot man!
 
Causeidm
I tried running it on after update, it doesn't run the code unless i click in
the text box and change the value.
Click to expand...

Well, how else does the value get changed?
The text box idea sounds good, I'm going to give that a try.
Click to expand...

Cool. Let us know.
 
Back
Top