Hello,
I have an Order form that has an Employee combo box with the list of employees from the Employee table. When I click and choose the name of the employee I get a message that "The field cannot be updated". But when I click OK button, it displays all information that is supposed to be on the form correctly. From what I read on the error the field can't be updated because another user or process has locked the corresponding record or table. However, I looked at the properties on the Order form and all other forms and tables leading to the Order form and Locked property everywhere was set to No Lock.
Any hints or ideas how to fix this problem? Thank you very much for your help.
I have an Order form that has an Employee combo box with the list of employees from the Employee table. When I click and choose the name of the employee I get a message that "The field cannot be updated". But when I click OK button, it displays all information that is supposed to be on the form correctly. From what I read on the error the field can't be updated because another user or process has locked the corresponding record or table. However, I looked at the properties on the Order form and all other forms and tables leading to the Order form and Locked property everywhere was set to No Lock.
Any hints or ideas how to fix this problem? Thank you very much for your help.