operation must be updateable query error?

[dhx10000]

Can someone tell me why this query is causing this error? I don't understand it:

UPDATE 1_2_06 SET ROLE = (SELECT ROLE FROM UserRoleData WHERE USERNAME=ASSIGNED_TO)
WHERE EXISTS (SELECT ROLE FROM UserRoleData WHERE USERNAME=ASSIGNED_TO);

thank you

 

[Pat Hartman]

See this thread
http://www.access-programmers.co.uk/forums/showthread.php?t=103479