Is look-up also look out? 1

[kupe]

I can't get this nor variations to work in the access2K db -

UPDATE tblEmpTransReq
SET tblEmpTransReq.TransferRequest = tblEmployees.TransferRequest
WHERE tblEmpTransReq. DB_id = tblEmployees.DB_id;

Is the likely failure because tblEmpTransReq.TransferRequest is a look-up field, please, Gurus?

 

[JerryKlmns]

Give it a try

UPDATE tblEmpTransReq Inner Join tblEmployees On
      tblEmpTransReq.DB_id = tblEmployees.DB_id
SET tblEmpTransReq.TransferRequest = 
                [tblEmployees].[TransferRequest]

 

[kupe]

Spot on, Jerry. Many thanks.