I have a form connected to a table but I want to make a macro that saves the original to a different table if the record is edited? So if any changes are made to any records it would copy that record and put it into the historic table I made.
Thanks.