How do I refer to a control on another form
How do I refer to a control on another form
(OP)
I am trying to perform the same function on combo boxes on different forms. I have 2 string variables called ControlName & FormName (i.e. FormName = "frmSchedule", ControlName = "tboDate"). I can use the frmSchedule.tboDate.value and it works fine but I'm trying to assign the form and control names to variables so I can use FormName.ControlName.value. Is there a way to do that?





RE: How do I refer to a control on another form
Dim objFormControl As Control
Dim objDateControl As Control
Set objFormControl = frmSchedule
Set objDateControl = objFormControl.tboDate
Debug.Print objDateControl.Value