I have an account table with a field called contactid. This field stores a code that relates to a contactId field in the Contact table. The contact table stores the name, phone, etc. of the person who is the contact for the account.

I have a combo box with the following properties:
.RowSourceType = 6
.RowSource = Contact.contact,contactId
(contact is the persons name, contactId is the Id number
.BoundColumn = 2
.ControlSource = Account.ContactId
.DisplayValue = Contact.Contact

I want to display the contact's name in the combobox (.DisplayValue = contact.contact), and I want the contact name to change to the appropriate contact when you move to a differenct account (.BoundColumn=2 and .ControlSource = Account.ContactId). This all works fine. The problem is when I try to edit the Contact's name in the text portion of the combobox. As soon as I type anything, the pointer in the contact table moves to the bottom of the table and writes the changed name in the contact field and writes a blank in the contactId field. The original record is still there. The pointer just seems to go to the bottom and overwrite the last record. Is there a setting that I am missing here?

-Ed