I have two combo boxes in a form for Repair Orders in an automotive repair shop: One is for the Repair Type (RepairTypeID) and the other is for the Repair Technician (EmployeeID). If I the Repair Order combo box first when the form is opened, I get the following Access error:
"Field Cannot be updated"
and when I click onto the Help button, I get the following:
"The field cannot be updated because another user or process has locked the corresponding record or table. (Error 3164)
Possible causes:
You tried to update a field in a record or table that is currently locked by another user. Wait for the other user to finish working with the record or table, and then try the operation again.
In Microsoft Access, you tried to change the value of a control whose Locked property is set to Yes."
But both locked properties are set to No.
If I click Ok a few times in the Access error dialogue box, the value enters into the field, and the Repair Technician combo box is okay, but if I reverse the process by clicking the Repair Technician combo box I get the same access error - "Field cannot be updated", and then I can click on the Repair Type Combo Box withe no problem.
Any assistance will be greatly appreciated. Thanks in advance.
r/David
Tidak ada komentar:
Posting Komentar