combo box recording incorrect values

  • Thread starter Thread starter PJFry
  • Start date Start date
P

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
 
Check the field properties in the table as it seems as though you have an
autonumber field instead of an integer field.
 
Back
Top