"Recordset not updateable"

[yawkey]

I have a database i inherited and i am trying to add some checks and balances to it for end users. There is a query I created called developmentStatus. It joins against 2 tables, MasterList and inDevelopment. I added a relationship between the two. If i run the query, i can update the fields directly throught the query. In addition, i have created a form that serves as a UI for the users to update said fields.

My issue is that though i can update the records from the query itself, however, i recieve a "recordset not updateable" error when trying to update through the form. I have all the properties i would expect, set to "Yes" to support updating. Has anyone ever experienced this? If so, what was the issue?

[June7]

Normally, a form can enter/edit records for only one table. Perhaps you need a form/subform arrangement.

If you want to provide db for analysis, follow instructions at bottom of my post.