combo box recording incorrect values

[PJFry]

I have a form with a combo box that looks up values from a table. There are
three columns, ID, lngClient and txtCompany from tSuppliers. The cbo is
bound on column 0. ID and lngClient are hidden.

When I create a new record and select a supplier, say Alpha Inc. it records
the next company on the list. In this case the ID for Alpha Inc. is 1 and
next on the list is ID 2, Beta Inc. The record created is shows Beta.

I have recreated the cbo, but I still get the same result.

Any thoughts on what is causing this? Let me know if you need any
clarification.

Thanks in advance.
PJ

 

[KARL DEWEY]

Check the field properties in the table as it seems as though you have an
autonumber field instead of an integer field.