Can't Modify Form Data

[mjbigelow]

Hello,

I've got a form that's record source is a query. When I view the
query, all the data is modifiable. However, when I bring up the form,
I can't modify the data. The type of query is just a select query.
The form has all edit permissions enabled. Any help would be greatly
appreciated.

Thanks in advance!
Mark

 

[Allen Browne]

If the source query is updatable, but the form based on the query is not,
then it must be the form's properties that are the problem (unless you have
security permissions set.)

The Data properties for the form should be:
Recordset Type Dynaset (i.e. not the inconsistent updates one)
Allow Edits Yes

It that's set right:
Is there anything destroying the keystrokes in KeyDown/KeyUp/KeyPress?
Is the form's Dirty or BeforeInsert event being cancelled?
Are the Locked and Enabled properties of the controls set correctly?
Is there any Timer event running anywhere that could be stealing focus?

 

[mjbigelow]

Hi Allen,

Thanks for the info. Unfortunately, none of the things you mentioned
are the culprit. However, I noticed that other records are working
while one in particular does not. Any ideas?

Thanks!
Mark

 

[Bill Mosca, MS Access MVP]

Mark

One record cannot be edited? What exactly is the existing value? And how are
you trying to edit it? Are you sure it will work in the raw table/query
itself?

Is there referential integrity set up between the table and another?