Form SubForm question 1

[puforee]

I have a Form (Location) Sub-form (Customer) Sub Sub Form (Items Purchased)

On Items Purchased I have fieds of Quanity and Price...I also have a computed field =[Quanity]*[Price] named Total.

On the Customer sub form I want a text box (CustTotals) to compute the sum of all the "Total" fields on the Items Purchased form.

I used this in the CustTotals field of the Customers form

=Sum([Sales SubForm].[Form]![Total]) and I get #Error

I know I have done something like this before...what am I doing wrong

 

[puforee]

Thanks Bob,

Also, can you answer one question about the code we used....
=DSum("Total","Sales Tbl Query","Location = " & [LocationID])

What does the last part " & [LocationID]) do. Can you explain this criteria please?

 

[boblarson]

What does the last part " & [LocationID]) do. Can you explain this criteria please?

The criteria is that we are trying to match the Location in the query with the [LocationID] which should be a control on your form which has LocationID bound to it. In this context you don't need to reference the form or anything like that if the control is on the same form where this control source is located. So we just use the control name in square brackets.

I hope that helps.

Bob Larson
Free Access Tutorials and Samples:

http://www.btabdevelopment.com

 

[puforee]

OK...I understand the Location comes from the Sales Tbl Query.

And I understand the LocationID is on the Location Form where the Unbound Text field containing =DSum("Total","Sales Tbl Query","Location = " & [LocationID]) is located.

But why the ampersand & befor the [LocationID]

Thanks,
John

 

[boblarson]

But why the ampersand & befor the [LocationID]

Because we want the VALUE of [LocationID] not the word [LocationID]. So instead of trying to evaluate the expression we are, by concatenating the reference in, giving the function the actual VALUE that [LocationID] represents.


Bob Larson
Free Access Tutorials and Samples:

http://www.btabdevelopment.com

 

[puforee]

Thanks...I will keep this in mind for future projects....that was the last question. Have a wonderfule day.

John