Blank textbox

[steve1111]

hi,

i have a subform with a textbox in the footer to count[id]. then on my main form i have another textbox that has a control source of =[subform].[form]![subformfootercontrol]. however when the subform updates the main form text is blank. typically i see a ?#Name or#Error if the control is pointing to the wrong place, but i have never see it stay blank. Any ideas what could be causing this?

thanks

 

[RuralGuy]

Here is a useful reference to bookmark:
http://access.mvps.org/access/forms/frm0031.htm

 

[CazB]

what exactly is the controlsource of the text box on the subform?

And does that text box show the correct number in it? Does it show anything?

 

[steve1111]

the subform txt located in the footer is txtCount and the ctrlsource is =Count([Last Name]) running the subform alone it does calc correctly. then on the main form txtTotal is the control name and then on click of a command button i have Me.txtTotal.ControlSource = "=[DriversAll subform].[Form]![txtCount]"

the reason i don't have the control source listed in the property sheet is i don't actually assign the control source of the subform until the on_click event of the command button so it doesn't run the subform query before the on open, saves some time loading that way.

I have tried listing the control source of the main form txtTotal in the property sheet for troubleshooting, but still say results, a blank textbox shows.