Subform calculations using a control source value....?

[merv805]

I have a purchase order database that has a subform with many products.

I have already placed a "sub-total" control that is

=[Quantity]*[Price]

The problem is that I can't seem to figure out how to use that control "sub-total" and calculate a grand-total within the subform.

Subform
Table: Product
Fields: Quantity, Price
TextBox(Sub-total)with Control source: =[Quantity]*[Price]

Is there an alternative method of doing this or is there a way to place that "Grand-Total" on my main form???

Can anyone help me with this simple question?? Thanks in advance!