Error # 3164 "field cannot be updated"

[bbrazeau]

I found that in my case this error was caused when I was trying to update a record on a form who's data source was a query and I had set a "Default value" for one of the fields.
Answer: remove the "Default value".Hope this Helps

[June7]

That seems odd. DefaultValue property should not cause a field to not be editable even if the RecordSource is a query.

[bbrazeau]

Hi June, Just to be clear, I got the error, but after dismissing it the changes were made anyways. Just unsetled me to have an error popping up like that all he time in my application. I removed the default values I was setting "0" and the errors went away. I don't know if I had applied the default values at the table level if the error would persit. I may try it and find out.
I got what follows below directly from MS web site:

Symtoms
When you type data into a new record on a form that is based on a query or an SQL statement, you receive one of the following error messages:
Field cannot be updated.
-or-
Multiple-step operation generated errors. Check each status value.
-or-
Start position is before the beginning or past the end of the rowset. No rows were returned.
When you click OK, you can continue to edit, and then you can save the record.

Cause
This behavior occurs when you try to update a read-only field in a record by using either the DefaultValue property or Visual Basic for Applications.

More information
When you create a form that is based on a query, any control that is bound to a query field that contains an expression is read-only. Because the
query expression is not bound to any specific field in the underlying table, you cannot edit the values in these fields. However, when you set the
DefaultValue property of such a control, Access tries to write a new value to that control every time that you add a new record.

[June7]

You mean you had set the DefaultValue property of a form control with an expression, not field in table. That does clarify and makes sense.