Help with Calculations on Subform and Mainform 1

[gypsi96]

I am in the process of designing an Equipment Quote Access DB. Where I am running into trouble is with my orders form and my Order Details Subform.

In the subform I have a calculation that takes [unitprice]-[unitprice]*[quantity]*[discount] to get my extended price.

I then need to total the extended price and carry that calculation forward onto main form for additional calculations for sales tax, freight charge etc.

Where I am lost is in the expression for the total of the extended price on the subform and how to then get that number onto the main form.

I've check a couple of articles etc but still either get a NAME# or ERROR# when I attempt the suggestions.

If anyone can help me, please email me.

Thank you

 

[ZmrAbdulla]

Try this article.

http://www.mvps.org/access/forms/frm0031.htm

________________________________________________________
Zameer Abdulla
Help to find Missing people
Sharp acids corrode their own containers.

 

[TheAceMan1]

How are ya gypsi96 . . .

[ol][li]Sum the subform field by using a calculated control in the subform's form footer.[/li]
[li]Reference the calculated control from the main form to display the summed value.[/li]
[li]ControlSource: =[subFormName].Form!SumControlName[/li][/ol]

See Ya! . . . . . .

 

[gypsi96]

AceMan,

Doing well, thanks.

Back into needing to design from scratch. Was hoping to mod a template but didn't work out well.

As for the Calculation, Brain cramp, and I don't have my bible on me today. How do I do the Calculated Control again. This is just a text box with calculation correct?

 

[TheAceMan1]

[blue]How do I do the [purple]Calculated Control[/purple] again. [purple]This is just a text box with calculation correct?[/purple][/blue]

A [purple]Calculated Control[/purple] is a textbox with the [blue]Control Source[/blue] set to an expression. Example:

[blue]=Sum(Nz([Extended Price]))[/blue]

See Ya! . . . . . .

 

[gypsi96]

Right, got it now. Thanks for the help as usual. Stellar!