Sum fields in child records to give a total in parent record

[jaromluker]

I have a one-to-many relationship defined between two tables. The parent table is represented on a form with the child table represented in a subform. I have a cost and a discount field in the child table that are shown on the subform. I have an invisible control on the subform with Control Source: =(1-[Discount])*([Cost]). The control name is "AdjustedCost". I would like the sum of all AdjustedCost controls to appear on the main form as a textbox. Is this possible? I've tried referencing queries, I've tried using DSUM, and nothing seems to give anything other than #Error and #Name?.

[Ruegen]

sum(putwhatyouwanttosumhere) - you can put that as a control source on a textbox and use VBA to plant/paste it into any row on the parent for a permanent record. Place it on the header part of the subform though...

[jaromluker]

[Ignore what I posted here.]

[jaromluker]

This doesn't change anything. You mentioned using VBA. I'm not as familiar with that as I'd like to be. Could you suggest some pseudo-code or something to pass this information to the parent, because right now the best I get is getting the AdjustedCost for the currently selected record on the subform, and not a sum of all the AdjustedCost controls from each of many records in the subform.

[jaromluker]

Solved the problem with DSUM. A lot of recommendations I've seen for DSUM show the criteria as follows: "[FieldName]=" & <code here>
I found that "[FieldName]=<code here>" solved the problem. I suppose that's because the data type for the particular field is a string, not a number. If someone out there could verify that for me...

So I used DSUM("(1-[Discount])*([Cost])","[Orders]","[AccountName]=[Forms]![AccountName].[CurrentAccount]") where I named the TextBox tied to the AccountName field in the parent table CurrentAccount.