Looking for a graceful exit

[pungentSapling]

does anyone know how to offer a good exit from a form. My form automatically populates two controls DATE and Employee #. I want to have a way so that the user can exit the form without creating a record related to the two auto-filled controls.

A way to cancell saving the record perhaps..

thanks

 

[David R]

In your Form, set the default value of those fields, not from code but simply via the Default Value Property (under Properties>Data).

As long as they have entered NO other data on your form, it will go away without harm at this point. If you need a way for them to back out of a record they've started entering look into a command button with Me.Undo behind it.

HTH,
David R