I Get Recordset Not Updateable Error Message In Access 2003

After closing down my Access 2003 database one night I found the following
morning upon opening the data base that one form & a different form subform
were not longer editable. AllowEdits, AllowAdditions, etc are all set to yes
.....

Help!!!

Peter ( New User )

If the form is based on a query, open the query directly.
Can you enter data into the query?

If not see:
Why is my query read-only?
at:
http://allenbrowne.com/ser-61.html
for a list of things to trace down.

If the query is updatable, but the form is not, check the properties on the
Data tab of the form's properties:
Recordset Type Dynaset
Data Entry No

Also, check the main form's properties. If the main form's AllowEdits is no,
you won't be able to edit in the subform either.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"CS440TTLSER" wrote in message
...
After closing down my Access 2003 database one night I found the following
morning upon opening the data base that one form & a different form
subform
were not longer editable. AllowEdits, AllowAdditions, etc are all set to
yes
....

Help!!!

Peter ( New User )

Is it possible that the form's RecordSource was changed to the name of a
non-updateable query? To check for "updatability", open the form and check
the RecordSource property. If it is a query, open the query itself and
attempt to change data.

Sprinks

"CS440TTLSER" wrote:

After closing down my Access 2003 database one night I found the following
morning upon opening the data base that one form & a different form subform
were not longer editable. AllowEdits, AllowAdditions, etc are all set to yes
....

Help!!!

Peter ( New User )