>Hi All,
>
>I need to check 30+ fields for changes and for each field changed, I need to put the date changed into a corresponding field.
>
>I thought about putting the old version of each field needed into a Name object on the form, then when they are saving the record to scatter the fields to a different Name object and compare them. But, I think, that is a lot of repetitive code.
>
>Anyone have a better way of doing it?
>
>TIA
>Beth
Check GetFldState() function in HELP.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.