Main form won't calculate subform fields

[scotribs]

I have a main form [Service Quotes] that has 2 sub forms [Components] and [Services].

Both of these subforms have a calculting text box [overall cost] that sums the cost of each item.

I have tried all the code I know to get calculate the 2 subforms totals onto the main form but constantly get an #name# error

Codes for the text box on the main form is:

=[Components].[Form]!.[Overall Cost]+[Services].[Form]!.[Total Cost]
(1st subform) (text box) (2nd subform) (text box)

I hope I have explained my problem ok.

Thanks in advance for your help.

 

[Dennisk]

there apprears to be !. between two object references. and the full qualifier is required for each text box

try this
=[Components]![Overall Cost]+[Components]![Services]
or Forms![Service Quotes]![Components]![Overall Cost] + Forms![Service Quotes]![Components]![Services]

 

[scotribs]

Dennisk

Thanks for the reply, I have tried both and now have an error 'item not found in collection'??