I am working on a job Entry form that is similar to your contact form.  I have a CustomerT that has an autonumber customerID field, a customer name field and a division field.  I started my JobEntryF as you did with your ContactF in Access 2003 video 4.  I brought in my CustomerID field, the CustomerName field and the Division field.  I tested the function of these fields and they cycle through my customers as they should with the autonumber, the corresponding customer and division.

I then created a combo box basing the values on my CustomerT and selecting the fields CustomerID (autonumber) first, then CustomerName and finally Division.  I sorted the records by CustomerName ascending.  I chose "Store that value in this field" and chose CustomerID.

I saved and went to form view, but when I tried to use the combo box I got a bell sound and a message in the status bar that says, "control can't be edited, it's bound to autonumber field 'CustomerID'.

What can I do to correct this?  My intention is to have this form as a basis to enter my new jobs in our database.  So ultimately this information will identify the customer in my JobsT.

---

Reply from Richard Rost:

Make sure that the CustomerID in your JOB ENTRY TABLE is NOT an AutoNumber. It should be a NUMBER of type LONG INTEGER. It's the FOREIGN key.