|
| 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
March 10th, 2010, 04:27 PM
posted to microsoft.public.access.forms
|
|||
|
|||
numerical summation to passed from sub to main form
I have a subform that tracks payments. I have a text box in the form footer
that calculates total payments. I need that total amount of payment passed to the main form, so that I can then calculate a "balance due" from Total Owed - Total Paid [which I do know how to do]. Thanks 
|
|
#2
March 10th, 2010, 04:49 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
numerical summation to passed from sub to main form
Set the controlsource of a text box on the main form to:
Me.NameOfSubformControl.Form.NameOfTextbox sunstituting appropriate names. -- Arvin Meyer, MCP, MVP http://www.datastrat.com http://www.accessmvp.com http://www.mvps.org/access "Keri in Vermont" wrote in message ... I have a subform that tracks payments. I have a text box in the form footer that calculates total payments. I need that total amount of payment passed to the main form, so that I can then calculate a "balance due" from Total Owed - Total Paid [which I do know how to do]. Thanks
|
|
#3
March 10th, 2010, 06:44 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
numerical summation to passed from sub to main form
It didn't work. Any other suggestions?
"Keri in Vermont" wrote: I have a subform that tracks payments. I have a text box in the form footer that calculates total payments. I need that total amount of payment passed to the main form, so that I can then calculate a "balance due" from Total Owed - Total Paid [which I do know how to do]. Thanks
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
