Access Main and subform subtraction and balance

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.

On Tue, 30 Mar 2010 15:09:01 -0700, Buildtk
wrote:

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])

--

John W. Vinson [MVP]