Adding calculated text box to main form

[samuelitz]

Hi guys,
In my Orders Form (with Orders details sub-form), I'm tryin to add a text box that shows the final Amount to pay.


Currently, this is the control source of the text box: =Sum([TblLink subForm].[Form]![Price]*[TblLink subForm].[Form]![amount])
But it doesn't work! the text box is Empty. What can i Do?

[RuralGuy]

I would sum it in the Footer of the SubForm (which may not be visible but it is available). Then simply reference *that* textbox.

[samuelitz]

Thanks, it's working great. I'm wondering if there is a different way, more elegant, to do so...

[RuralGuy]

Hmm...it is the way I've always done it. I resist manipulating forms from other forms. Reaching in and getting results that form made I find elegant. Just my $0.02.

[Missinglinq]

Allan's suggestion is pretty much the accepted approach for this kind of thing. IMHO, doing math involving Fields displayed in a Form is better off being calculated in that Form, and then simply referencing it from another Form; you're simply pulling one piece of data from the original Form, rather than multiple pieces of data.

Linq ;0)>