Since you want the value of the first column to be stored in the table, set
the BoundColumn to 1.

Since you want the value of the second column to be displayed, set the
ColumnWidths property to 0. (if you really wanted to, you could set it to,
say, 0;1" to ensure that the second column only shows as 1 inch wide)

Make sure the ColumnCount property is set to 2.

--
Doug Steele, Microsoft Access MVP
http://www.AccessMVP.com/DJSteele
Co-author: Access 2010 Solutions, published by Wiley
(no e-mails, please!)

"gator" wrote in message
...
Can someone please explain in layman terms, the purpose of BoundColumn in
ComboBox in terms of viewing two columns when dropped down and storing one
value in the table and displaying different value in the form?

I want to be able to see two columns in drop down mode, column 1 value
stored in table and column 2 value displayed in form data view.