Excel VBA code to copy specific records from one access table to another - Object Required

I have an access database that receives information from an excel userform. I then have another excel spreadsheet that pulls the data back from access depending on search criteria. What I would like to have is a macro that starts when certain cells are clicked which will move the record from 'TABLE1' to 'TABLE2' in access.

The code I came up with is attached in an excel spreadsheet as my firewall is blocking all SQL injections apparently?

Thanks in advance,

Danny