Combo Box

[Charles Elman]

I need to select various records in a database for member.
I have set up a combo box, with two columns, the first
and ID (hidden), the second a surname.
The combo box selects the record correctly, BUT it causes
the ID of the next surname to be written to the surname.
After every amendment to a record, I have to exit the
routine, open the members table, and correct the surname.

 

[John Spencer (MVP)]

Sounds as if you have bound the combobox to the field. NOT a good idea if you
are using the combobox to select the next record.

Remove the binding from the combobox and use a separate control to show the
current values of the name and id (if you want to show that).

In other words, you cannot use one combobox for navigation and for setting the
value for the current record.