[ms_access] Update Query

[shaetal]

I am trying to update the Tracker ID column in incident handling table 
with the UserID value from the User table.

here's my query and it errors out on the Set value.

UPDATE IncidentsHandling SET Tracker_ID = (select Users.User_ID where 
IncidentsHandling.Tracker_Name = Users.Name);

any idea how to do this?

thanks,
shaema