sum amount in my subform to text box in main form

  • Thread starter Thread starter Revned
  • Start date Start date
R

Revned

Hello,

I have my mainform with a subform name [child101] bound in
table [tblOrder].

in my tblOrder there is a column name [Total Amt]
is there anyway to accomplish in summing the [Total Amt]that is in
my subform and the result of summation will appear to [txtSubtotal]
that is in the main form??

can anyone help how to do that,iam using access 2003

thanks for any help
 
Revned said:
I have my mainform with a subform name [child101] bound in
table [tblOrder].

in my tblOrder there is a column name [Total Amt]
is there anyway to accomplish in summing the [Total Amt]that is in
my subform and the result of summation will appear to [txtSubtotal]
that is in the main form??

can anyone help how to do that,iam using access 2003
Click to expand...


Set the main form text box's expression to reference the
subform text box that sums the total:

Subform header or footer text box (named txtTotal)
=Sum([Total Amt])

Main form text box:
=child101.Form.txtTotal
 
Back
Top