how do i add a calculated text box of subform to the main form

A

Arleta

How exactly do i add a calculation preformed on the footer of the subform and
get it to show up on the main form without the #Name error. I have tried to
follow the directions in help. I have looked at other forms that do it. I
have used the expression builder to make sure the name is correct in the main
form box. What am I doing wrong!
 
J

John Vinson

How exactly do i add a calculation preformed on the footer of the subform and
get it to show up on the main form without the #Name error. I have tried to
follow the directions in help. I have looked at other forms that do it. I
have used the expression builder to make sure the name is correct in the main
form box. What am I doing wrong!
Click to expand...

I'm not sure, since you don't say what you're doing.

You need to use the subform control as the Control Source of the
mainform textbox. The syntax is a bit peculiar - you need to use the
Name property *of the Subform control*, which is not necessarily the
same as the name of the form in that control!

Try setting the control source of the mainform textbox to

=subMySubform.Form!txtCalcTextbox

where subMySubform is the name of the empty box on the main form which
contains the subform, and txtCalcTextbox is the name of the control on
the subform.

John W. Vinson[MVP]
(no longer chatting for now)
 
Top