After update event

S

Sue

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
 
A

Al Camp

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
 

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

Top