Syntax question...

[Rockman]

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):

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)):

Public Sub ChangeText()
Dim sControlName as String

     sControlName = "txtTest(2)"
     Me(sControlName).Text = "foobar"

End Sub

Any help would be most appreciative!
Jeff

[gdebacker]

This does work...

Dim sControlName As String
    sControlName = "txtTest"
    Me(sControlName)(2).Text = "foobar"

Greg

[Rockman]

SUPER Greg!

Thanks a bunch!
Jeff

[hellswraith]

Another way you can do this:

Dim sControlName
    
    Set sControlName = txtText(2)
    
    sControlName.Text = "foobar"

[hellswraith]

Forgot to add this for control array:

Dim sControlName
    Dim intCount As Integer
 
    Set sControlName = txtText
    
    For intCount = 0 To 2
       sControlName(intCount).Text = "foobar"
    Next intCount
 
    Set sControlName = Nothing