Cannot edit table with forms

R

roccogrand

What would cause forms to be locked for editing? All forms associated with
table/queries fail.

Allow Edits, Allow Deletions, and Allow Addtions are all set to Yes.
I have broken the relationships and removed objects that are no longer
needed thinking that the relationships were bad. And I have closed Access
and restarted it several times.

Other forms linked to other tables/queries in the db work fine.

Thanks.
 
S

Sprinks

Try editing the form's underlying query directly. If you are unable to do
so, the query is "non-updateable". Often this is caused by a primary key
being included from the one side of a one-to-many relationship, but Google
"non-updateable queries" for more complete information.

Sprinks
 
Top