"Field Cannot Be Updated" Error

[DavidG]

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.

 

[dcichelli]

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.