Sorry for the confusion, Pat is on the path i am trying to get to. I am new to VBA, so don't mean to cause any thing.
I want to insert a copy of any record that has changed, pretty much i want to copy every record as a new record if a field has been changed but not copy if nothing has been...