Referencing specific column in combo box

[Glenn_Suggs]

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:

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

[June7]

You appear to be on right track.

Me("cboFieldName" & Format(Ctr,"00")).Column(1)

This assumes the value you want for each combobox is in the same column position.

[CJ_London]

to add to June's comments, columns start from 0, so column(1) is the second column

[Glenn_Suggs]

Thanks, June... That does work great. I thought I had tried that syntax actually but maybe I got one of the parenthesis out of place. Anyway, thanks for the help.