Access Main and subform subtraction and balance


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.
 
Ad

Advertisements

J

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top