>There's got be a clean solution to this problem and I'm sure someone have done this kind of thing before.

Of course, the best thing for this is a Trigger... but, a trigger doesn't allow for you to write into the record which tripped the trigger.

You could try to create a record validation rule which replaces Modified with .t. then just return .t.. Of course, the rule could be a stored proc so that this would happen if the change was made outside the ap.

BOb

Of course, I think the right way to do this is in your UI... in the valid of a control turn on your modified flag. This way, if you tablerevert the modified flag would revert too.