Checking Variables for any change?

[Richard A. Starkey]

Hello all,   I have created a form for entering or editing data about a specific client which includes Approximately 39 variables.  There are also three command buttons which open MDI forms for additional information if needed.    My problem is: What is the easiest way I can check which variables have been changed.  I would then update only the appropriate table / tables (Approx. 10 tables) that are affected.  I do not want to do a total update for all the variables, which seems to be the easiest, because there are fields in all the tables that track who and when any information has been updated/changed.  I do not want to update these fields if no change has been made to that table.     Any help or insight would be greatly appreciated.   Rich S.