Access blocks all update queries when grouped queries are included. Use DSUM instead.

UPDATE Second_Table SET SumField=DSUM("NumberField_First_Table","First_Table","WHERE ID_in_First_Table=" & [ID_inSecond_Table]);