I have a main form and a sub form.
Subform has a number of fields which is linked to TABLE1
Subform footer has a hidden text field called TXTSUM which sums up the total amount entered in the subform. This is the outbound field where the formula is =sum([Approved])
Now in the main form...