Hi all expert,
I am trying to do what I stated in the title through MS Access 2010 VBA. But I am not successful. Please give me some insights and the VBA code if possible.
Thanks,
Hi all expert,
I am trying to do what I stated in the title through MS Access 2010 VBA. But I am not successful. Please give me some insights and the VBA code if possible.
Thanks,
You don't need vba,
link the destination table into your db.
create an append query from your local source table to your target table. It will use the key on the form as criteria.
you can put a button on the form COPY, which will run the query , docmd.openquery "qaCopyRec"
insert into tTargTbl ( field1, field2) select field1, field2 from tSrcTbl where [field3]=forms!myForm!txtKey