URGENT! very simple update not working

[BennyLinton]

I have a table Billing_Temp that I need one field updated if I find a match in another table Random_Temp. I runt the query and it prompts for "Enter parameter value: Random_Temp.peopleID... what could be going on? Both tables have a field called peopleID and always Billing_temp has many more records than Random_temp:

UPDATE Billing_Temp SET Billing_Temp.audited = -1
WHERE (([Billing_Temp].[peopleID]=[Random_Temp].[peopleID]));

 

[BlueIshDan]

UPDATE billing_temp, random_temp
SET billing_temp.audited = -1
WHERE billing_temp.people.id = random_temp.peopleid;