Cant refer to control on subform from another subform. Both subforms are on the main form.
Posted on 2012-09-21
I have a main form, "frm_Switchboard" and two subforms on it: "frm_BU_Profile_Selection" and "frm_Profile". There are other subforms in other tabs as well, but these are the two I am concerned about here.
On the main form I have a tab control, and the two subforms are each in their own tab. However, I have read from many sources that assure me that the tab control has no impact on how I reference the controls.
I am trying to place the value from this textbox, "frm_BU_Profile_Selection!txtSelected_BU_Name" into the following textbox, "frm_Profile!txtBU_Name", but all of the syntax that I try, fails. Sometimes I get the "#Name?" and sometimes I just get a blank field in frm_Profile!txtBU_Name, depending on the syntax.
Can you please tell me what the correct syntax is for making this reference?