updating using a query

[angie]

I have a table name “proposals”
I have a query name “proposals query”


I have a form name “proposal”
In the query I have a field “Financed Price: Round([price]+[addons],0)” because I needed it to calculate.
The field “financed price” in the table is not update withthe information added to the field in the form which is created using thequery. The form and query works greatand calculates correctly but how do I get the field “financed price” in thetable to update .
Thank You
Angie

[RuralGuy]

Here's a link that should help explain what you see: http://allenbrowne.com/casu-14.html

[angie]

thank you for the information, I tried the following
I am using the following that you sugested
You want to store a calculated result anyway?
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 itto 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 cost text box
Private SubFinanced_Price_Change()
Callprice_afterupdate
End Sub

Not surewhat I am doing wrong

[angie]

I changed what I was needing so I am going to mark this solved because I am needing help with afterupdate event in a form to make it work so I reposted thank you
not sure if this is the right way to move something or change what I need it to do.
sorry if its not the right way