recordset not updateable

[nkrst1]

I'm using Access '97 to build a small application and it's driving me crazy because it keeps saying my recordset isn't updateable.

Basically I have a form with a subform. I change the recordsource property of the subform dynamically based on what tab the user clicks on.
The recordsource is a query that joins two tables (1 -1 relationship).
I want the user to be able to edit one of the fields on the form to update one of the tables. I've tried so many things. I'm at a loss.


The subform recordset property is set to Dynaset.

 

[HAH]

There is a property called "Allow Edits" have, you make sure is set to Yes?

 

[nkrst1]

Yes, allow edits is on.