I have a combobox with RowSourceType of "SQL SELECT", RowSource with SQL-SELECT statement, and a Controlsource of the name of the cursor created by SQL statement. The SQL pulls in data from 2 fields of a table, second being primary key of the table.

The problem is, when I set the combobox's BoundColumn property to 2 for the PK column, shouldn't the Value of the combobox same as my PK??? Well, it isn't and I can't see why it isn't. I think I've used the combobox this way for a long time but I don't think I've run into this problem before (or did I just forget something simple?)

TIA
John.