Automatically total(sum up) in main form based on subform

[leonhuynh2006]

Dear all bro,

Presently, I am facing the problem that I can not update Total Price in the main form when entering value in subform. Please take a look at my file and help me. (Please open forms-->tb_order-->Total price(in yellow)(not the total))

I am very appreciated for your helping

[orange]

What does Total Price(yellow) represent? Where does it get its value from?

[leonhuynh2006]

it represents total price in subform. However, when I enter the value in the records of subform (I have used many ways :Afterupdate, on current,..), non of them works....

[orange]

What is the difference then between the calculation for Total and Total Price (yellow)?


There is a calculation defined for Total on the Form and it is working.
Total Price (yellow) is a value in your Table. No need to store a calculated value in your table.
Given your record 1, what value do you think should be in Total Price(yellow), and how would the data get there??

[hertfordkc]

Dear all bro,

Presently, I am facing the problem that I can not update Total Price in the main form when entering va lue in subform. Please take a look at my file and help me. (Please open forms-->tb_order-->Total price(in yellow)(not the total))

I am very appreciated for your helping

column in your subform. Add an "afterupdate" that will transfer the total from this query to the appropriate field on the main form. You may need to have the total transferred by other events as well, to insure that you have a total displayed even if the subform isn't touched.