hurrysundown
Technical User
This will likely be really simple for anyone with experience. But I have looked thru MS Access Help, Northwind database, this forum and three Access books and cannot find this answer.
I am designing a simple form using two tables. I want to include a combo box control based on an employee table that will allow me to display and change the person responsible for a task.
Following all the examples I have seen, I opened the form in edit view, used the controls wizard, selected the combo box and placed in on the form by dragging the EmployeeID (Primary Key and autonumber field). I told the wizard I wanted to look up the values in a table, selected the Employee table, selected two fields (EmployeeID and Name), hid the key column as recommended and was left with one column as I expected.
The Control Source is EmployeeID; the RowSource contains both EmployeeID and Name; The column count is 2; the bound column is 1.
Whenever I run the form and try to change the assigned employee, I get the message in the subject line -
"Control cannot be edited; it's bound to autonumber field "EmployeeID".
Can anyone provide a solution please? Thank you.
I am designing a simple form using two tables. I want to include a combo box control based on an employee table that will allow me to display and change the person responsible for a task.
Following all the examples I have seen, I opened the form in edit view, used the controls wizard, selected the combo box and placed in on the form by dragging the EmployeeID (Primary Key and autonumber field). I told the wizard I wanted to look up the values in a table, selected the Employee table, selected two fields (EmployeeID and Name), hid the key column as recommended and was left with one column as I expected.
The Control Source is EmployeeID; the RowSource contains both EmployeeID and Name; The column count is 2; the bound column is 1.
Whenever I run the form and try to change the assigned employee, I get the message in the subject line -
"Control cannot be edited; it's bound to autonumber field "EmployeeID".
Can anyone provide a solution please? Thank you.