I do not believe Jet (the database engine Access uses) supports table-level triggers, so you'll need to use a macro or VBA code in a form to trigger the extra record.

I'm attempting to connect to an excel file using an ADO recordset. There is a column in this that I need the sum of for a report. I'm familiar with ADO connections, so I assumed this would be the most ...