Thanks for everyones input.

My state office does not "buy" 3rd party software and I did not want to get into that much coding since I was only trying to archive as history for nothing other than on-demand display and I have to keep it maintainable(uncomplicated???). Our office wants to "keep it simple", so I opted to scatter current data to an array property as aOldVlaues on edit.click then insert appropriate data into a free table for on-demand display history on save.click.

Thanks again, Chuck

>I am having a time trying to devise a way to track changes to a table so that the user can see what pieces of a record changed, by whom and when. I was going to create a table to archive record changes to so that the user could click a button to browse(noedit) all changes to that record. I don't know if this is the best way and trying to determine how to keep before and after changes.
>
>I have looked for other threads here and other sites but can't see to ask the right search question.
>Any help is appreciated, Chuck