CurrentDb.Execute "UPDATE tblPurchaseDetail INNER JOIN tblStocksDetail ON tblPurchaseDetail.PurchaseDetail_ID = tblStocksDetail.PurcDetail_ID SET tblStocksDetail.Article = [tblPurchaseDetail]![Article];"
aşağıdaki kodu dener misiniz?