Refere Column from a Comb box

[le888]

Hi,

What is the syntaxe refering to a comb box column. I have a combo box which has 2 column and I would like to refere the column 2 to a text box. Example:

In the text box Me.txtColName, the control source = me.combo box name.column.[2]

However, this syntaxe doesn't work. Any ideas?

Thanks,

Le

 

[pbaldy]

Textbox control source:

=[cmbVehicle].column(2)

 

[le888]

Thanks.

Le