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.

Ok, so I've got an Access database and accompanying user interface written in VBA, and I need to make it so our users (who really aren't that computer savvy, but let's assume they are mediocre) cannot ...