>I need to check to see if a value has changed on a form and if it has, record this by placing the before and after values into a memo field in the same table, along with the User's name and date/time the change was made; is there a simple way to do this?
Cecil,
Check XMLUpdateGram() and XMLTable.ApplyDiffGram methods. I used a variation of those successfully to backup and restore tables chronologically to a given time.
PS: Variation was about generating a compacter and faster version of updategram. However it was much harder to code. Just using XMLUpdateGram() should be sufficient.
Cetin