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