Microsoft Access forms made for quick data entry of large volumes of records should consist of a simple top-to-bottom layout. Get step-by-step instructions on how to create a simple data entry form.
Prevent users from changing data by using Access form control properties Your email has been sent Access allows you to prevent users from inadvertently changing data on their forms. Here's how to set ...
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.