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.

Users expect a certain level of functionality from their web applications. While sorting and paging through data tables doesn’t top the list of developer favorites for feature programming, they are ...