afterupdate event in a form

[angie]

You want to store a calculated result anyway?


I am using a afterupdate in a field to generator the stored calculated amount.

My field name is “ equipt cost”

It gets it data from a combo box selection

I entered the following on the change event but can not get it to work

Private SubEquipt_Cost_AfterUpdate()
Me.Financed_Price= Round(([Price] + ([Price] * 0.075 + 840)) / 0.47 / 0.88 + 750, 0)

End Sub

And thefollowing to the finance price text box
Private SubFinanced_Price_Change()
Call price_afterupdate
End Sub

Not surewhat I am doing wrong

[CJ_London]

not sure what you are trying to do. what does 'can not get it to work' mean?

I entered the following on the change event - of which control?

why are you updating financed_price in a cost afterupdate event when any change to the cost has no bearing on the calculation?

and what is the price_afterupdate event?

[angie]

http://allenbrowne.com/casu-14.html

I was following the "you want to store a calculated result anyway"
I was going to use a calculated field in a table but was told not a wise thing to do, I still need to store this in a table so I was using the after update property.