Allow Edits, Deletions, and Additions turns to NO, WHY?

[KLP]

I have a sub-form where the Allow Filters, Allow Deletions, and Allow
Additions should say Yes; however, they switch to No by themselves. I am
stumped as to how this happens and how to stop it. I edit the form, go into
Properties, then under Data, change those 3 fields to Yes, save the form, and
it works. Then one of the times when I open the form, the sub form doesn't
allow deletions, additions, etc., so I have to edit the form and turn them
back to Yes. I can't seem to find a reason for the automatic change. It
isn't like I change to Yes, save it then the next time I reopen the database,
the change didn't stick - it does stick ... then comes "undone." Any ideas
would be greatfully appreciated

 

[robeito]

Here are some ideas:

Define a primary key in your table and see if the problem persists.

Also, you can restart with a clean form

Greetings

 

[KLP34]

Table does have a primary key. I've removed the sub-form and put it back, to
no avail. I guess the next step is to recreate the form from scratch to see
if it continues.

Thank you,
Kelvin