Sum Function Error

[tmac]

I having problems with Access and the sum on forms.



Tables: Products, KITS, Kits Subdata



Products are a list of products of course with part numbers and pricing.

Kits is a list of kits, KitID, Descriptions, ect.

Kits Subdata = KitID, Part#, ProductName



In my Kits form, I have subform named "Kits Subdata subform"



In the kits form, I have [Total Cost] =[Kits Subdata
subform].Form!SumofParts



In the form "Kits Subdata subform", it refences the kits subdata table
for part#(combo box that has lookup into products table), quantity, then
I do a dlookup in the control for price



In the subform header, I have SumofParts = Sum([price]*[quantity])



It seems when I lookup the price field, I get error for sum?



Can a calculted or lookup field be in the sum expression? If not, what
is the correct way.



thanks



tim

 

[tmac]

I figured this one would be easy? Any takers?



thanks tim