>I have a button on a form that brings up another form, when I load this form and do not add record but just close it stores the default info into the table when it should not. what can I do to correct.
>
>Thanks Bill

Is this child form called to add a new record? How do you handle saving? A Save button? Do you also have a Cancel button? For data entry, I always have a Cancel button on the form so the user has an explicit cue that they can abort any changes or additions. In fact, this is the only avenue they have for canceling. My form base class has a SaveData method that fires whenever the form is released unless it is released by clicking the Cancel button. The Cancel button sets a form flag to indicate the Cancel was clicked. Then when the form releases, the RevertData method fires instead. All of this requires either optimistic row or table buffering.