Update Query not working 1

I have a table with a field named "Complete". When I update data in this table I also want to check to see if work has been completed. If it is completed I don't want the user to see the completed items. The users work on items that are not complete due to errors. Not all items have errors so many are not used. Once those items are completed I want to remove them from user visibility to reduce a selection list that the users use.

I use a query to find the Items that are complete from an input table. I then created an update query on the (IPSS Classes) table linked to the query Update Complete Field. In View mode this shows the correct field to modify based on the item number. View runs fine but Run returns:

A Warning indicating changes cannot be undone. "expected"
Operation must use an updateable query. "not expected"

Here is my query code:


IPSS Classes.Complete is a check box in the table

I need the first query to find the items that are completed in the input data. These are the only items that should be updated in the IPSS Classes table complete field.

The completed value is from a different table than the IPSS Classes table. A little confusing but .... Suggestions?

Thanks, John