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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Run Macro If Cell have "x" value 0
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Tweaking a calculated field in a query 4
re-post : a question about percentages and money 3
RecordsetClone.Recordcount not counting correctly 10
More Formula Help 3
Excel Macro to automatically go to the right of the last colored cell 0
Macro works Macro does not work 4

Back
Top