ERROR in combo box

[wotamelon]

ERROR in combo box,

Scenario: when creating combo box with wizard, forgot to select the primary key as well.

i.e. 2 columns: primary key (auto no.), products

So when the combo box is bound to a field list, the end text shown on the table ends up as the auto no. (NOT the title of the products)...


is there a way to change that without doin it again with wizard because I've got about 23 combo box that are already bound to a field list.


PLEASE HELP

 

[Galaxiom]

Edit the RowSource property of the combo to include the missing field in the query.

Check the Bound Field is the right one. The numbering starts from zero.
Change the ColumnCount property to suit.
Set the ColumnWidths property to zero for the PK field. eg. 0cm;3cm