After Update Event

[aandress]

I have this code (as a sub) posted as an Event Procedure on the After Update of a field called ManagedAssetValue:

Select Case ManagedAssetValue
Case 10000 To 250000
Fee1 = ManagedAssetValue * 0.02

Case 250001 To 500000
Fee1 = ((250000 * 0.02) + ((ManagedAssetValue - 250000) * 0.015))

Case Is > 50000
Fee1 = ((250000 * 0.02) + (250000 * 0.015) + ((ManagedAssetValue - 500000) * 0.01))
End Select

I was hoping to get it to post the calculated value in the Fee1 field on the same form.

Nothing appears in the Fee1 Field at all... What am I doing wrong??? Help!

OH... also, the value in the ManagedAssetValue is also a value that is calculate (by a formula in the control source of the field).

Help...
Thank you!!

 

[Jack Cowley]

I attempted to answer your question on another forum. Lets see what you get here...