Access Main and subform subtraction and balance

[Buildtk]

I have a main form Contributors and a subform Contributors subform. On the
contributor form I have a Pledge box with the amount pledged in it. On the
subform I enter payments under Amount Paid after each payment I want the
balance to show on the subform until the Pledge is paid in full. or the
balance can show up on the Main form. I just need to track the amount owed.

 

[John W. Vinson]

I have a main form Contributors and a subform Contributors subform. On the
contributor form I have a Pledge box with the amount pledged in it. On the
subform I enter payments under Amount Paid after each payment I want the
balance to show on the subform until the Pledge is paid in full. or the
balance can show up on the Main form. I just need to track the amount owed.

Try putting a textbox on the subform's Header or Footer with a control source

=[Parent]![Pledge] - Sum([Amount Paid])