Let me explain my situation. In my edit form i have two unbound text fields and one bound checkbox field. The two unbound text fields will be append to field in the database when click save button. The thing when user uses close button, all the unbound text fields won't be save it. But the checkbox field will be save. If use DoCmd.RunCommand acCmdUndo, and use didn't change anything for check box, it will show up a message, unod is not available.
Thanks. This is great idea. I am going to append the check box and create cancel button to unsave. The questsion is when append the check box, it shows the value is 0 or 1, how to change it to "Yes" or "No".
The way I've always done this (and I thought this to be really the only way, with slight variations out there), is to have as many unbound text boxes and check boxes as you need. Then you copy the info into the controls from a rs. That way the users are working with "dummy" info, it doesn't matter what they do to them.
Then you have a Save button similar to the one you have; only this button on the On Click event will load whatever is in the controls back into the table. If the user chooses to close early without clicking the save button, it won't affect any of the data in the table, they'll just loose they're dummy data (I usually msgbox the user at this point to make sure they don't need to save the data).