A2003: How to get unbound col from combobox?

[bulrush]

A2003 on WinXP

I have 2 columns in a combo box called cbxAddSalesman. The first column is bound, so in VBA I can use that value like this:
s=cbxAddSalesman ' Give me bound column.

How do I get the second column of cbxAddSalesman in VBA?

Thanks.

p.s. The source data for the combo box is an SQL statement.

 

[DCrake]

Each column in a combo is zero based indexed so to get the second column

Salesman = Me.CboSalesmen.Column(1)

 

[bulrush]

Thank you!