Sub Form calculation

[Keiath]

I have a order system,

On the purchase order form I have a Sub form for the orders.

Each line has a Line price ie:- ( qty*Price=total) I want to display the total order price outside the sub form. Whic I have done but it only adds the first line of the order, how do I get it to add all lines (there could be 2 or 5 order lines) to give me a grand total

Thanks

 

[spikepl]

In header or footer of subform, make a textbox txtOrderTotal, and as control source type =Sum([qty]*[Price])

On main form make a textbox txtOrderTotal, and in the Control Source input the reference to the text box on the subform.

 

[Keiath]

In header or footer of subform, make a textbox txtOrderTotal, and as control source type =Sum([qty]*[Price])

On main form make a textbox txtOrderTotal, and in the Control Source input the reference to the text box on the subform.

I have tried this just as you have said and i get a #error returned

Any ideas?

 

[spikepl]

The error is in line 42, right?

 

[Keiath]

The error is in line 42, right?

its just returning in the target txtbox #Error

Doesn't say anything about Line 42..... (sorry a little bit new to access)