"but it just requests a value for TableA.Field_1."
Then Field_1 is not a fieldname in TableA


Try this MS Access syntax

Code:
UPDATE TableA 
INNER JOIN TableB ON TableB.Field1 = TableA.Field1 And TableB.Field2 = TableA.Field2
SET TableA.Field3 = TableB.Field3;