Thank you for challenging me, I did it this way and that works too!
UPDATE tbl1 SET tbl1.myDate1 = #12/12/2012#
WHERE tbl1.myDate2 =(SELECT Max(tbl1.myDate2) AS MaxOfmyDate2
FROM tbl2 INNER JOIN tbl1 ON tbl2.ID = tbl1.ID
GROUP BY tbl2.EmpID
HAVING tbl2.EmpID="xxx");