Help! Need to calculate and store value based on total in Subform

[ezra]

I am trying to create an invoice program that will automatically generate an invoice based on charges entered in a subform. Sounds easy enough!

I have created my Total field on subform as unbound and called it Ttl. I have used this code to tally the total of all charges =Sum([Charge]). This works fine. I have then put a GrandTotal filed on my Customer info form and asigned it this value =frmCharges.Form!Ttl. Again, the field total looks fine as long as I only enter one charge. Problem is I there will be multiple charges for most invoices!
I have entered the recalc code in the OnChange but still nothing.

What am I doing wrong here!!

[puppydogbuddy]

I am trying to create an invoice program that will automatically generate an invoice based on charges entered in a subform. Sounds easy enough!

I have created my Total field on subform as unbound and called it Ttl. I have used this code to tally the total of all charges =Sum([Charge]). This works fine. I have then put a GrandTotal filed on my Customer info form and asigned it this value =frmCharges.Form!Ttl. Again, the field total looks fine as long as I only enter one charge. Problem is I there will be multiple charges for most invoices!
I have entered the recalc code in the OnChange but still nothing.

What am I doing wrong here!!

ezra,
The OnChange event does not fire for calculations or updates via code. It fires only for changes due to data input. Try to move the recalc code to the Form_BeforeUpdate() event for the subform, and see if that helps.

[ezra]

ezra,
The OnChange event does not fire for calculations or updates via code. It fires only for changes due to data input. Try to move the recalc code to the Form_BeforeUpdate() event for the subform, and see if that helps.

Thanks

The form field does calculate properly now but the correct total doesn't stored in the Total field in the underlying table.

[puppydogbuddy]

Thanks

The form field does calculate properly now but the correct total doesn't stored in the Total field in the underlying table.

ezra,
as a general rule calculations are not stored in the table because they can derived any time from the stored components any time it is needed. However, if you want to store it irregardless, you can. Add the following line to the Form_AfterUpdate() event of your subform, assuming that the subform record source is the table that has the total field.

YourFieldName = Me!YourControlName