Access Main and subform subtraction and balance

  • Thread starter Thread starter Buildtk
  • Start date Start date
B

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.
 
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.
Click to expand...

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

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