I've got a form with multiple nested subforms (four total including the main form -- the thread title is slightly misleading, but it was easier to type). In last of these nested subforms (the sub-sub-subform) I threw an unbound textbox (which i've named txtsubtotalsum) into the footer with a dsum expression to calculate a sales subtotal. In the subform above that one (the sub-subform) I need to grab the value from txtsubtotalsum and display it in its own textbox to be used for an order total.
I created that textbox (txtordersubtotal) and the value displays as it should if the sub-subform is open in its own window, but if I have the subform or mainform open, it returns a #Name error. I checked all my names to see if there were any conflicts and couldn't find any. Is there anything else that could be causing this problem?