It's because when you create a combo box that uses a table or query as it's
row source it usually automatically adds the ID as the number associated with
the comboboxs pick.

So you can do multiple things to change this

1. Go in to the properties of the combobox, and go to "Bound Column" and
change it from 1 to 2.

Or if you go in to the event of the combo box you can change the

me.yourcombobox.column(2) instead of just me.yourcombobox

either one should work. Hope this helps.