It is your query. It is not updateable. When you pick data from many joined tables, the query can become read only. The reason being that Access cannot figure out which piece of information in which record you want to update. You will want to set your key information for the tables that are involved in the query. By telling Access that a certain field is a unique (no duplicates) Access will be able to determine what field/record needs to be updated. If you have your keys set up and the relationships setup, then you will have to do it with more than one recordset. Use the original SQL to find the records, then use a second recordset to search and update the records.
I was able to make it updateable but still it does not update. If I copy the string stored in sqlStatement and make a query from it, I was able to change the value of the fields but if the code is executed in VBA, it does not give me an error but it doesn't do anything either.