Access 2007 Query Help

tblDues

I want to add Year = 2008 and StateDues ='120' for all contact records who have a record in table Dues for 2007

SELECT tblDues.ContactID, tblDues.DuesYear, tblDues.StateDues
FROM tblContacts LEFT JOIN tblDues ON tblContacts.ContactID = tblDues.ContactID
WHERE (((tblDues.DuesYear)=2007));

I have tried a subquery but it won't run in Access:

Update tblDues
SET tblDues.Year = '2008', tblDues.Amount = '120.00'
where tblDues.ContactID in
(select tblContacts.ContactID from tblContacts, tblDues
WHERE tblContacts.ContactID = tblDues.ContactID
AND tblDues.DuesYear = '2007');

This returns "This operation must use an updateable query"