Combo box variables

[Doo-Dah Man]

Hi,

How do I assign a variable to the combobox name property? For
example, I am trying to do this:

dim strComboName as string
strComboName = cbo1.Name
strComboName.RowSource = "some list"

I have many combo boxes and I want to set the name with a variable. I
have tried various combinations trying to concatenate the variable
with the rest of the .RowSource property to no avail.


Any suggestions?

Thanks!

 

[Graham R Seach]

Dim strComboName As String
strComboName = cbo1.Name
Me(strComboName).RoiwSource = "SELECT....."
....or...
Me.Controls(strComboName).RowSource = "SELECT....."

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

Microsoft Access 2003 VBA Programmer's Reference
http://www.wiley.com/WileyCDA/WileyTitle/productCd-0764559036.html

 

[Doo-Dah Man]

Dude you are totally awesome. Thanks!

Dim strComboName As String
strComboName = cbo1.Name
Me(strComboName).RoiwSource = "SELECT....."
...or...
Me.Controls(strComboName).RowSource = "SELECT....."

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

Microsoft Access 2003 VBA Programmer's Reference
http://www.wiley.com/WileyCDA/WileyTitle/productCd-0764559036.html