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.

 

[Pat Hartman]

The Bound column is the one that will be saved. You need to change your bound column. You can use the column widths property to show/hide various columns of the rowsource. So you can show the name field but store the id field.