I used the following VBA code to modify a table field:
Currentdb.execute "Update tblTarget_sr INNER JOIN tblMerged_test ON tblTarget_sr.[Customer Part]=tblMerged_test.[Part No] SET tblTarget_sr[Target total time]=tblMerged_test.[total time]
But I have more three fields in Update tblTarget_sr that need to modified at the same time while the above condition met.
Please advise me what would be the VBA code to modify other fields.