Sum Caluclating on change in form 1

[DarkOne72]

Hello,
I tried searching the forms area first for thi but can't find what I need exactly so here it goes.

I have a form that has a QTY field and Amount field; at the bottom of that field I have a sum field: =Sum([Amount]*[Order_QTY]+[BackBar_Purchases]). That is working fine but if I change the QTY it won't update the sum area with the new amount until I change records and go back or close and reopen it.
My question is, is there a way to make a change on event so if you change the QTY it will automatically update the sum field down bottom without changing records or closing it?

Thanks in advance

 

[PHV]

In the QTY AfterUpdate event procedure:
Me.Dirty = False

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[DarkOne72]

PHV,

Thank you for the code it worked great but I have one small problem; It shows the correct amount on the form but in the table it is just saving the original amount not multiplied by the qty any idea why?
IE.. Amount is 5.00 and QTY is 3 the form shows correctly 15.00 but in the table for that field it is only showing 5.00 in the total amount.

Thank you again

 

[PHV]

Are you saying that you store derived/calculated values in your table ?
Have a look here:

http://r937.com/relational.html

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[DarkOne72]

I have 3 fields Amount, QTY, Total Amount
Everything updates the table properly, but in the total amount field I have the formula =SUM([Amount]*[QTY]in the control source and it shows the correct Total Amount in the field on the form. however in the table there isn't anything showing at all for the total amount field.
how do you get it to show the calcualted number in the table under the total amount.

(I know i said it only showed the 5.00 in previous post but I was wrong after re-evaluating)

 

[PHV]

You shouldn't have a "Total Amount" field in your table but in a query doing the math.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886