numerical summation to passed from sub to main form
in [Form]
|
From: Keri in Vermont on 10 Mar 2010 11:27 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
From: Arvin Meyer [MVP] on 10 Mar 2010 11:49 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" <KeriinVermont(a)discussions.microsoft.com> wrote in message news:6EE0D5F1-6336-4484-8DF2-590786C47345(a)microsoft.com... >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
From: Keri in Vermont on 10 Mar 2010 13:44 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
|
Pages: 1 Prev: DoCmd.HourGlass not working Next: Checkbox will not check |