How to append a record with an attachment field to another table?

[John Bloor]

I have a Microsoft Access 2007 database that uses a form whose recordset is a products table that contains an attachment field. From that form, I need to be able to append the current record to another table using vba code tied to a command button. There may be several attachments in each record.

Can anyone provide me with ssample code that will achieve this please?

Thanks