Macro not working

[Guest]

I created a macro that stores a calculated value from a field in my form
(FieldA) to another field that will be stored in a table(FieldB). (I know
that you normally shouldn't store calculated values but in this case it was
necessary.)

I created a macro that used the SetValue action to set the value of FieldB
to the value in FieldA (so that the value can be stored in the table). I
created a command button that runs the macro OnClick and it works. However,
I want the macro to run when FieldA is updated. I tried putting the macro
under the OnUpdate property of FieldA but it isn't working. I tried putting
it on all on the On...Properties and it doesn't work. Is there a problem
because it's a calculated value? How can I run the macro without using a
command button? Thanks.

 

[ruralguy via AccessMonster.com]

Call the macro from the AfterUpdate event of the FieldA control. It may also
be necessary to have something similar in the Current event of the form.