Text field in Subform

[PJ]

I have a text field with the name of "Total:" and control source of
"=sum([requested cont liab amount earmarked])" in a subform named
"frmContLiabBorrowerEarMarkedInfoSubform". I want a text box in the main
form "frmContLiab" with the same text box. I keep getting "#Name?" or
#Error. What am I doing incorrect?

Thanks in advance

 

[Tom van Stiphout]

On Fri, 1 May 2009 11:53:01 -0700, PJ <[email protected]>
wrote:

The expression would be:
=subformControlname.form.controlnameOnSubform
so in your case (drawing a big breath):
frmContLiabBorrowerEarMarkedInfoSubform.Form.[Total:]

The last part is in parentheses because of the special chars used in
the control name.

-Tom.
Microsoft Access MVP