VBA update record problem

Set rs = CurrentDb.OpenRecordset("SELECT tbl142.LoanNo, tbl142Assignments.assigned, tbl142Assignments.dateAssigned FROM tblEmployees RIGHT JOIN (tbl142Assignments RIGHT JOIN tbl142 ON tbl142Assignments.LoanNo = tbl142.LoanNo) ON tblEmployees.ID = tbl142Assignments.assigned WHERE assigned IS NULL", dbOpenDynaset)
rs("assigned") = rsEmps("ID")

I know that this code works with a normal query that doesn’t involve any joins. There a way to make updates to a recordset that has joins in it such as this?