Field Cannot Be Updated Error Message

[Guest]

HELP!!

I have a form whose underlying query can nicely be edited, including the
addition of new records. However, when trying to enter data in the form, and
as soon as the first character is typed in any field, I receive the "Field
Cannot Be Updated" error message. I have checked the previous messages on
the discussion groups regarding this, and Microsoft's knowledge base, and
nothing has worked so far.

Any other thoughts????

 

[Larry Linson]

HELP!!

I have a form whose underlying query can nicely be edited, including the
addition of new records. However, when trying to enter data in the form, and
as soon as the first character is typed in any field, I receive the "Field
Cannot Be Updated" error message. I have checked the previous messages on
the discussion groups regarding this, and Microsoft's knowledge base, and
nothing has worked so far.

You'll need to debug -- find out _why_ the field can't be updated and fix
it.

Here are some questions to research: (1) right-click the upperleftmost
little box in the design view of the form to show the properties, if they
aren't showing, and look at the "Allow Edits" property, which should be
"Yes" (2) look at the DataEntry property, which should be "No". Allow
Additions (means allow adding new records) and Allow Deletions (means allow
deleting records from the DB) should not matter in regard to this problem.

Larry Linson
Microsoft Access MVP

 

[Guest]

Hello Larry,

Thanks for your reply. Unfortunately, the "Allow Edits" property is set to
"Yes", and the "Data Entry" property is set to "No". Any other thoughts /
suggestions?

Franklin