Main form won't calculate subform fields

scotribs

New member
Local time
Today, 17:31
Joined
Dec 16, 2007
Messages
8
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 :mad:

Codes for the text box on the main form is:

=[Components].[Form]!.[Overall Cost]+[Services].[Form]!.[Total Cost]

I hope I have explained my problem ok.

Thanks in advance for your help.:)
 
try:

Code:
=[Components].[Overall Cost]+[Services].[Total Cost]


Note: It is possible to edit your post!
 

Users who are viewing this thread

Back
Top Bottom