Since I started to program with Access I've always had a problem cancelling a record. For instance I have a OK and a Cancel button on a form. From the user point of view he/she has the impression that clicking OK will close the form and save the data.
On the other hand clicking Cancel should close the form and discard
the data entered. I understantand that the:
is very useful in this case. But sometimes the data can be commited to the table (maybe it was saved because there is a subform in the main form and clicking in the subform saves the data in the main form).
I suppose the Dirty property of a form can hint as to if the entry can be undone or not.
Anybody has experience with using a Cancel button on a form and make it work like the user expect it. Care to join this interesting thread? I am sure many people can benefit for this conversation unless it is me that doesn't understant a thing!!!