SQL to Update field from another table

please also read this article:
https://www.experts-exchange.com/Database/Miscellaneous/A_1517-UPDATES-with-JOIN-for-everybody.html

sjwales - The query you gave errors with "Operation must use an updateable query"

angelIII - Thank you for the link, but my problem now is time, or the lack of, which is why I posted this as a question instead of researching why my query didn't work.

What database are you using?
What version of the database?
What is your query?
What is the error you are getting?

Is it something with ASP?

Found this in the MS Knowledge Base: http://support.microsoft.com/kb/175168

Sorry,  I thought I had posted this in the Access area.

I'm using Access 2010

No, it's not related to ASP

I running Access 2010 and querying a local native database.

The query that gives the error is:

update tbl_Vendors a
set  LastPayment = (select max(DateReceived) from tbl_Parts b where b.VendorId = a.Id)

The error appears to be an Access error, which is outside my expertise - hopefully one of the Access experts will chime in.

Thanks everyone.  What I was trying to do with a single query apparently can't be done in Access.  I've split the points because sjwales's solution would have worked if it wasn't access and LukeChung-FMS showed me why it wouldn't work and gave the work arounds.<br /><br />I appreciate the help!