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.

I have a form with a 'View' button on it that will open up a continuous form (which looks like a datasheet) which simply lists all the records from the same query as the original form. I want to be ...

Keeping track of random ideas can be challenging if you don't write them down when they occur. If you're updating an Access form, for example, you may wish to jot down a quick note about the form or ...