If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
Access Main and subform subtraction and balance
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] |
Thread Tools | |
Display Modes | |
|
|