After update event

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Sue - 31 Oct 2005 21:42 GMT

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

Reply to this Message

Al Camp - 31 Oct 2005 22:08 GMT

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

Signature

hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

>I have a text field tryong to update another feild on the same form with
>the
[quoted text clipped - 8 lines]
> Me.Less_Value_of_Surrend__Shares = Me.Value_of_Shares_Swapped
> End Sub

Reply to this Message

Sue - 31 Oct 2005 22:34 GMT

That worked putting it into those other after update feilds. THANKS SO MUCH

> If ValueOfSharesSwapped is a calculated field, as you seem to indicate, the
> AfterUpdate event won't fire when the calculation value changes.
[quoted text clipped - 18 lines]
> > Me.Less_Value_of_Surrend__Shares = Me.Value_of_Shares_Swapped
> > End Sub

Reply to this Message