Setting a control

[BasicBoy]

I wish to set a control of which I only have its name stored in a database in a string field 'cboList' like in:

Set MyControl="cboList"

It gives an error because the string "cboList" is not a control object.
Thanks for help

 

[Andrzejek]

Dim c As Control

For Each c In Me.Controls
    If c.Name = "cboList" Then
        Set MyControl = c
        Exit For
    End If
Next

If you do that a lot in your code, I would set a little Function where you pass the name of the control as String, and return the control as Control.

Have fun.

---- Andy

There is a great need for a sarcasm font.

 

[strongm]

Which you'll notice is pretty similar to the answer you got in thread222-1680716