You may be able to use the DoCmd.RunSql command. I'm still puzzled by the syntax, but many things puzzle me.
'Define the values into variables
'Define the SQL string
strSQL = "INSERT INTO tableName([ssn],[transaction_type],[transaction_amount],[transaction_notes] VALUES (""" & strSSN & ""","""...