Hi Folks,
Here is a situation that I came across that really threw me for a loop. (No pun intended) I'm trying to reference a column in a combo box using this format:
Code:
For Ctr = 1 to 10
SomeField = Me("cboFieldName" & Format(Ctr,"00"))
Process the data here
Next Ctr
where the code is looping through several combo boxes and processing each in turn. So the combo boxes are named like this:
cboFieldName01, cboFieldName02, etc.
Does anyone know of a way to reference a specific column in the combo box using this format? All I need is the syntax (If there is one for this.) If I can't find a way to do it, I'm afraid I'll have to re-write a whole bunch of code that really works great otherwise. Then I'll be changing all the references to use this:
Me.cboFieldName01.Column(0), Me.cboFieldName02.Column(1), etc.
Thanks in advance,
Glenn