I have a Main Form with 3 Combo Boxes and a Sub Form, when selections are made from the 3 Combos, the Sub Form updates, and fills in some Text Boxes. Once these Text boxes are filled out in the Sub Form, I want the 3 combos to fill 3 Global Variables, and one of the Text Boxes in the Sub Form to fill out the final Global Variable.
However, I seem to be having trouble filling out the Varible form the Sub form, the 3 combos are easy, simply;
StrTEST = cboTEST
But I don’t seem to be able to the reference the Sub Form Controls from the Code in the main Form.
So when I do something like;
StrANOther = Frm_SubForm.txtSupport
I get an error “Method or Data Member not found”
Is there a nice neat way of picking the Variable from this text box? I’ve even tried picking up the Variable from the text box update event, but it still wont pick it up… may I’m just making a stupid mistake!
Thanks for your help.
Dave