If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
"Field Cannot Be Updated" Error
Form:Form(1)
View: Datasheet Record Source: Query(1) Table Source: Multiple tables Problem: Entering data into any control in a New Record causes the "Field Cannot Be Updated" message to appear twice. (After clicking "OK" on the error message window, the data is accepted into the control.) Clicking the "Help" button on the error window indicates the error is 3164: possible problem - record locked by another user. (There is no other user.) I have 11 other forms built in the same manner, using the same tables and relationships used by Form(1) which do not have this problem. I'm hoping someone can point me to where I might find the problem. Any comments would be greatly appreciated. |
#2
|
|||
|
|||
"Field Cannot Be Updated" Error
Hi David -
Unfortunately, based on the underlying rules of databases, you cannot update a value in a form (or query) based on a query that draws on multiple tables. You might want to revisit your underlying database structure and combine any tables that follow standard normalization rules. Or, you could restructure your form to incorporate subforms and / or macros that pop up a related form. DavidG wrote: Form:Form(1) View: Datasheet Record Source: Query(1) Table Source: Multiple tables Problem: Entering data into any control in a New Record causes the "Field Cannot Be Updated" message to appear twice. (After clicking "OK" on the error message window, the data is accepted into the control.) Clicking the "Help" button on the error window indicates the error is 3164: possible problem - record locked by another user. (There is no other user.) I have 11 other forms built in the same manner, using the same tables and relationships used by Form(1) which do not have this problem. I'm hoping someone can point me to where I might find the problem. Any comments would be greatly appreciated. |
Thread Tools | |
Display Modes | |
|
|