After update event

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

Guest

I have a text field tryong to update another feild on the same form with the
after update event. It is not working. The first field is set as a number
with a default value calcualtion(not to be stored). But that value is passed
to another text field in my form and it is not working. The code is below.
can you help.
SH

Private Sub Value_of_Shares_Swapped_AfterUpdate()
Me.Less_Value_of_Surrend__Shares = Me.Value_of_Shares_Swapped
End Sub
 
If ValueOfSharesSwapped is a calculated field, as you seem to indicate, the
AfterUpdate event won't fire when the calculation value changes.
If your calculation were, for example... ValueOfSharesSwapped = Price * Qty
Then you would use the AfterUpdate event of Price and Qty to set the value
of LessValueOfSurrendShares

Me.Less_Value_of_Surrend__Shares = Me.Value_of_Shares_Swapped
or...
Me.Less_Value_of_Surrend__Shares = Price * Qty
 
Back
Top