What is the best way to look at a record and see what was changed before updating it?
Example:I have a Record and if the Products or Customer Instructions changed I want to mark it as a revision.
If nothing else changed but just adding a truck number and name when they sign in I just want to update the record and not mark it as revised.
So I need to look at the existing record and see what was changed before updating.
Unbound Form so I am writing the record and updates with VB which works fine, just need this to complete it.