Close form *without* saving

[Tommy P]

Hi! By default, Access saves the record that you're working on when yo
close the form. But is there any way of making a button that closes th
form *without* saving the record? I've written code to clear all th
fields and then close the form, but I just end up with a load of blan
records! Any help would be much appreciated

 

[JL Picard]

Hi Tommy,

Le mer, 28 jan 2004 at 18:04 GMT, Tommy a écrit:

Hi! By default, Access saves the record that you're working on when you
close the form. But is there any way of making a button that closes the
form *without* saving the record? I've written code to clear all the
fields and then close the form, but I just end up with a load of blank
records! Any help would be much appreciated.

You can use this code in the <Button>_Click() Event functon :
Me.Undo
DoCmd.Close