copying calculated data on a form to a bound field on the same form

[bkberg05]

Hi - I have a form called 'Order'. It has a subform called 'Order_Detail'. On the 'Order_Detail', I have many records for each order record.

On the footer of the subform (it's a continuous form), I have a sum field (called Sum_Sub) which calculates the sum of a field. This works fine.

On the main form, I have an unbound field (called Sum_Main) which references the sum field on the subform. This works fine.

Each time the value of Sum_Main changes, I want to copy this data into a bound field on the Form (called Total).

I thought it would be a piece of cake and tried adding it to the AfterUpdate and then the OnChange event of the Sum_Sub and the Sum_Main fields, but no dice.

Any assistance would be greatly appreciated.

Thanks,
Bill

[NeoPa]

@bkberg05
You were doing so well up to that point. You had a main form, and a sub form, both clearly explained and referenced, then suddenly you're talking about "the form" which in this context is at best confusing.

If you can clarify this I'm sure we can offer some assistance.