sum amount in my subform to text box in main form


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
 
Ad

Advertisements

M

Marshall Barton

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


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
 

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

Top