Combo Box help

[jkoer]

I have a combo box that gets its values from the second column in a two column table, with the first column being numbers and the second being words. I just made the width of the display of the first column 0 so it wouldn't show up in the combo box. Whenever I select a word from the combo box, the number from the table shows up in the spreadsheet that the form is attached to. How to I make the spreadsheet display the word (ie how do I make it display the values in the second column instead of the first). Any help would be greatly appreciated.

 

[John Big Booty]

Change the Bound Column to 2 it is probably set to 1 at present. You will find this property on the Combo's Data Tab when it is in Design view.