I need to Sum a calc. control in subform and show in main form

Hello,

I have a main form called Customers that has info such as phone, address
etc. Then a subform called orders which has shipping and tax info and the
orders subform has a Order Details subform that contains the specific info
and price of each item.

I currently the order details subform calculate the exact price of each item
(excluding tax). Then the orders subform sums the price of each item and
adds the shipping cost which is the total for each customers order.

Now I need help displaying the total or sum of each order in the main
Customers form. Everything I try either gives me an error! anyone have any
ideas?

Thank you in advance,
Beth

On my website (www.rogersaccesslibrary.com), is a small Access database
sample called "SubformReference.mdb" which illustrates how to do a number of
things referencing controls on subforms and subsubforms, including this.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/...UBED1=ACCESS-L


"Beth" wrote in message
...
Hello,

I have a main form called Customers that has info such as phone, address
etc. Then a subform called orders which has shipping and tax info and the
orders subform has a Order Details subform that contains the specific info
and price of each item.

I currently the order details subform calculate the exact price of each
item
(excluding tax). Then the orders subform sums the price of each item and
adds the shipping cost which is the total for each customers order.

Now I need help displaying the total or sum of each order in the main
Customers form. Everything I try either gives me an error! anyone have
any
ideas?

Thank you in advance,
Beth