bound columns

[mkelly]

I have a combo box that pulls down customer name and auto fills a text box with the customer #.
The bound column is 3 which is the customer # however I want to save coloumn 1 which is the ID to the table.
Can I do this? any suggestions?
thanks in advance

 

[RichMorrison]

Mike,

See Access Help for the "Column" property.

You will find explanation and examples.

RichM

 

[IgorB]

Use Combo1.Column(0) for the first field in combobox.