Close form *without* saving

  • Thread starter Thread starter Tommy P
  • Start date Start date
T

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
 
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
 
Back
Top