selected rows in a subform to record in other table

[ASandoval]

Hi
I need to record in a TableA, the selected rows by a user in a subform using VB.
Example...
A subform display 9 records (rows) of TableB and the user select 3 of them, what I need is that the selected rows (with all the fields that have (8 fields)) be record in TableB.
Can someone help with this?
Thanks
Alex

 

[vbaInet]

Why the duplication of data?

 

[ASandoval]

Why the duplication of data?

The information in the subform is a "resume" of different tables. The information that is recorded in TableA is "audited" and export to another system for security matters
Regards
Alex

 

[vbaInet]

I still don't see why you need to duplicate data?

Look into Docmd.runcommand accmdcopy and docmd.runcommand accmdpasteappend