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.

Excel VBA allows you to call an external function or module with a simple "=NameOfFunctionToCall" entry in the code syntax. However, in .NET applications, you should always use the "Call ...

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 ...