Field cannot be updated.

J

jeff

I have created a program and I keep getting this message.
Field cannot be updated.
- I already check and there is NO LOCKS.

Can someone help.

Thanks in advance.

Jeff-
 
A

Arvin Meyer [MVP]

Typically, calculated fields can only be updated in code or by SQL. Other
reasons are that you have an aggregate (Totals) query, or you don't have a
recognizable key in the query which means the form or query can't figure out
what to update. This usually happens when you are attached to non-Access
data. If your field is not calculated, and isn't one of these other
problems, perhaps you might tell us a little more about where it resides in
the database and how you can update it from the table.
 
Top