You do not need the Subform, unless you want it for display purposes to do the transfer.
It can be done directly to the table using a recordset.
I use that to balance stocks when sales are made and that kind of work.
Let me know if you want or need to do that kind of thing.