X xolo Registered User. Local time Today, 23:52 Joined May 6, 2009 Messages 34 Dec 28, 2009 #1 How do I refer to a control on a subform (with variable names) using something like this method: Forms(FormVariableName).Controls(ControlVariableNames) in VBA?
How do I refer to a control on a subform (with variable names) using something like this method: Forms(FormVariableName).Controls(ControlVariableNames) in VBA?
boblarson Smeghead Local time Today, 09:52 Joined Jan 12, 2001 Messages 32,059 Dec 28, 2009 #2 Code: Forms(FormVariableHere).Controls(SubformControlHere).Form.Controls(ControlOnSubformHere) The SubformControlHere refers to the control on the main form that houses the subform (not the subform itself).
Code: Forms(FormVariableHere).Controls(SubformControlHere).Form.Controls(ControlOnSubformHere) The SubformControlHere refers to the control on the main form that houses the subform (not the subform itself).
boblarson Smeghead Local time Today, 09:52 Joined Jan 12, 2001 Messages 32,059 Dec 28, 2009 #3 Plus you might find this a good read.
X xolo Registered User. Local time Today, 23:52 Joined May 6, 2009 Messages 34 Dec 28, 2009 #4 Thanks a lot Bob!
