Is it possible to create a trigger in Access?
I have a table that has 500 records. On occasions, a user will use a form to modify a record in that table. What I want to do is create a trigger (or something like a trigger) that copies that one updated/modified record into a seperate table. Is this possible?