F
Fav
I want to add all sub-totals in my sub-form to a total in the main form. How
do I do it
do I do it
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
N
NetworkTrade
You need to pull them all together in an event; possibly the OnCurrent event
of the form...(although I'm not 100% certain the subform values are set
before the main form is current...try it)....or maybe you want to put in a
calc button and use its OnClick event...
Each value is identified by: Me.SubformName.Form!ControlName
the 'Me' and the 'Form' are literal - otherwise insert your actual names
of the form...(although I'm not 100% certain the subform values are set
before the main form is current...try it)....or maybe you want to put in a
calc button and use its OnClick event...
Each value is identified by: Me.SubformName.Form!ControlName
the 'Me' and the 'Form' are literal - otherwise insert your actual names
V
vbasean
I want to add all sub-totals in my sub-form to a total in the main form. How
do I do it
I use the dsum function
add an unbound textbox to your form
go to the textbox properties and set it's datasource something like
this
=DSum("[field you want to total]", "[table field resides in]","[child
field of the related table] = " & [parent field on form])
http://www.techonthenet.com/access/functions/domain/dsum.php
N
nomadk
add an unbound text box on your form with a Control Source like
=SubFormName.Form!Subtotal1+SubFormName.Form!Subtotal2+SubFormName.Form!Subtotal3...
=SubFormName.Form!Subtotal1+SubFormName.Form!Subtotal2+SubFormName.Form!Subtotal3...