set value macro not working

  • Thread starter Thread starter blueman
  • Start date Start date
B

blueman

I have an unbound calculated text box called "text 33"

I also have a control on the form called "Total Travel To"

I created a set value macro to set the value of "Total Travel To" to
the value of "text 33" once "text 33 is updated. It is of course set
to the update property of"Text 33". If I run the macro manually it
works fine however it will not run when "text 33" is updated or
changed. Can someone help. I do not know VBA and don't have time to
learn it.This is a program I built for my business.

Thanks
 
Looking at you post I "think" you could just the the control
source of [Total Travel To] like this

=[Text 33]

If there is another reason why you can't do this then ensure that the marco
is set to run on the right event AfterUpdate and that there is nothing else
on the form that will stop this
 
Back
Top