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.

After creating UserForm1 for one Excel application, you realize that you'll want to use it again -- with a few modifications -- in another application. You do not need to recreate the form; simply ...

The VBA editor saves the macro code as a .BAS file. Use the "Export File" option on the "File" menu bar to export all of the other macro modules from the Excel workbook that you want to convert to ...