Post deleted by puma

I ran across a similar problem before. I think that the problem lies in the fact that you are using a join in your SQL statement. From my experience you cannot update a table from a recordset that was created with any type of join. (This sucks...I know. You should be able to but you can't) So how I got around it was to have two (or however many tables you are editing )additional recordsets that just access one table and edit your tables from these recordsets, then you can requery your joined recordset and it should work fine. It can be a pain to write the code to have the unjoined recordsets keep up with the joined one, or you can use a do until loop to find the right entry.
Good Luck
Rick