>I don't think I'm asking for unlimited undo. Every app I've ever used has a save/cancel button and I expect cancel to undo any changes. To have it do anything else would be unheard of IMO.

It certainly sounded like you wanted unlimited undo. I still think you need to explain more about what is happening. At this point I'm guessing that you're editing a record, your not saving it, you edit it again, cancel and the original value is lost? IF so, are your sure you are using table buffering and not record buffering?