I need to reference a control array from a string variable, but the fact that it is an array is causing a syntax problem. This may explain it better...
THIS WORKS (if I have a text box named txtTest):
Code:Public Sub ChangeText() Dim sControlName as String sControlName = "txtTest" Me(sControlName).Text = "foobar" End Sub
THIS DOESN'T WORK (if I have a text box array with txtTest(2)):
Any help would be most appreciative!Code:Public Sub ChangeText() Dim sControlName as String sControlName = "txtTest(2)" Me(sControlName).Text = "foobar" End Sub
Jeff




Reply With Quote