The rowsource of your combo should be "Select prodID,prodName,prodDesc from tblProducts. (or whatever your products table name is)
The column count would be 3
the column widths would be 0,2,0
doing this has the description in the 3rd column of the combo box which would be referred to as the 2nd column because the columns are zero based (0,1,2)
the columns with a zero width are hidden so you only see the prodName in the combo.
In the after update event of the combo you would have
Code:
sub cboBox_afterupdate()
txtBox = cboBox.column(2)
end sub
which takes the hidden column(2) of the combo and inserts the value into the textbox.