cancel button

[quibus]

hey,
I'd like to use a cancel button on a form. The problem is that there are several field on the form. When I fill in some of the field and then press cancel, the data that was filled in is saved. I don't want it to be saved...what is the solution for this??
I allready set Cancel Property to Yes ; and made a procedure with:
DoCmd.Close acForm, Me.Name

 

[thornmastr]

You are doing too much. Build your cancel button. Then in the on click event of your button, put the following line of code.

me.undo

This will cancel everything the user has done.

Then, if you really want to close your form, simply add this further line of code

docmd.close acform,me.name Robert Berman
Data Base consultant
Vulcan Software Services
thornmastr@yahoo.com