=Forms!NameofMainTable!NameofField

[louisa]

Anyone have any ideas how i can make this work? the field has a =SUM([TotalPrice]) formula inside so my corresponding field has a Name? displayed not the value. Thanks for your help.

 

[vbaInet]

Not quite sure what you're getting at but with the Name? message displayed have a look at the Control Source of the control and ensure it is a valid field.

 

[missinglinq]

My guess would be that [TotalPrice] is a calulated field, and you cannot run Aggregate Functions, such as SUM, against a calculated field! You have to run them against the Expression used to do the calculation. In other words, if

A + B = C

you cannot use

SUM(C)

but have to use

SUM(A + B)

 

[louisa]

Sorry i wasnt really clear, I have a form called Equipment and in the footer of my form i have a a field with a control source of =SUM([TotalPrice]) this then provides the total of all the amounts in my form. I also have another form called Commission, inside that form is a field called TotalKitCost instead of entering the amount manually i was hoping to use the =Forms!NameofMainTable!NameofField, set up instead of manually entering the data. However as the forms control source is a formula i dont know how i can get it to work.

 

[vbaInet]

There are other ways but you could just use a DLookup() function instead:

http://www.techonthenet.com/access/functions/domain/dlookup.php

 

[louisa]

Thanks for the great link, i have been researching and this looks like the best way to go however i am having difficulties knowing what i need to set my criteria to. I am a beginner in access so any help you can give would be greatly appreciated.

 

[vbaInet]

There should be a field that relates both forms? Use that field as the criteria.

Here's one more link that you may find useful:

http://www.mvps.org/access/general/gen0018.htm