I created a subform on my main form, and in this subform is a text box that sums up one of the feilds. I created the subform to obtain this sum, and need it to appear in a text box on my main form.
Since i dont need any of the other info from the subform, i have its visibility turned off and in the text box on my main form i have the control source set to:
=Forms![ACTUAL FEET Subform]!Text8
ACTUAL FEET subform is obviously the name of my subform and Text8 is the name of the text box that i need to copy on the subform.
It is currently giving me the #Name? error in the text box on the main form.
Any ideas on how to fix this?
Since i dont need any of the other info from the subform, i have its visibility turned off and in the text box on my main form i have the control source set to:
=Forms![ACTUAL FEET Subform]!Text8
ACTUAL FEET subform is obviously the name of my subform and Text8 is the name of the text box that i need to copy on the subform.
It is currently giving me the #Name? error in the text box on the main form.
Any ideas on how to fix this?