Macro not working

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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.
 
Back
Top