Changing bound column of an cbo box changes cbo box value

[brharrii]

I have a combobox that pulls its list from a query and stores it in one of my tables. There are 4 columns in the query,

AuditorId
FirstName,
LastName
Expr1 (firstname+lastname)

The combo box originally used column 1 (firstName) as the bound Column. When I change it to Column 0 (auditorID) as the bound column, the value in my comobox changes. The value in the actual table stays the same, but the combox on the form shows a different name simply by changing the bound column. When I change the bound column back to column 1, it reverts back to the correct name.

Does anyone have any idea what may be causing this?

thanks