numerical summation to passed from sub to main form

K

Keri in Vermont

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
 
A

Arvin Meyer [MVP]

Set the controlsource of a text box on the main form to:

Me.NameOfSubformControl.Form.NameOfTextbox

sunstituting appropriate names.
 

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

Similar Threads

Access Main and subform subtraction and balance 1
Reducing Balance on Invoice 9
Subform Calculated Field Used on Main Form to Sort Results 1
Reporting in main form total of subform field (in continuous forms 5
Calculating a text box 9
Connecting Payment Data In Two Forms 2
Form/subform totals don't balance when subform empty 1
How force table update when no bound field updated? 1

Top