Sum of Subform in Mainform

[carlton123]

Im using a calculated filed in the footer then showing that value in the textbox in mainform(bound) which is working fine the only problem is im using it on change Event to update the textbox which shows the last Sum total instead of the new one any help please

 

[stopher]

Hi and welcome to the forum.

The textbox on your main form should not be bound. There's no need to store data that can always be calculated.

Instead, just reference the subform textbox with something like this as your source:
Forms![main form name]![subform control name].Form![control name]

hth
Chris