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.

How do I count the number of records in table using VB code? For instance, I have unkown record number in a particular table, and I want to do a loop statement to execute a query to fill data into the ...