Recordset not Updatable.

[Guest]

I am getting an error message stating "Recordset not updatable." when I try
to edit a data field in a form.

The form is based on a query that contains data from a table and other
queries.

Each of the tables and their associated queries all have a Primary Key. In
fact, the primary Key is the same in each table.

Did I do something wrong on the design end? (I am able to create a query
with just one table and update the information. It is only when I join to the
other queries do I have this problem)

TIA

Antonio

 

[Allen Browne]

Antonio, if you open the query directly, can you edit the data there?

If not, here's a brief list of possible reasons:
Why is my query read-only?
at:
http://allenbrowne.com/ser-61.html