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.

Follow the steps below on how to create a tabbed form in Microsoft Access: A Field List pane appears on the right. In the Field list pane, you will see a list of fields in your table or tables ...

I have a combobox that I want to populate with a list of vendors stored in another Access Database. This database contains roughly 1,300 different vendor records. All I'm interested is the ...