need an "Abort" button

  • Thread starter Thread starter Dave Cullen
  • Start date Start date
D

Dave Cullen

The default behavior for Access is to update the database when the
record loses focus in a form. There's no "Abort". I need to provide an
escape mechanism so that a user can choose to not save a record.

This is especially important when the focus is on an existing record and
the user accidentally changes something.

So, I have two questions:

Can a form be setup to not display the contents of the database? If a
blank form shows up by default, that'd eliminate the possibility of
accidentally overwriting. I also want to eliminate the default
next/previous/first/last controls on the form. Only new data should be
possible.

Secondly, can I create an "Abort" button that will close the form
without saving the current record?

Or, if someone has a better solution I'd be grateful.

Secondly
 
Dave Cullen said:
The default behavior for Access is to update the database when the
record loses focus in a form. There's no "Abort". I need to provide an
escape mechanism so that a user can choose to not save a record.

This is especially important when the focus is on an existing record and
the user accidentally changes something.

So, I have two questions:

Can a form be setup to not display the contents of the database? If a
blank form shows up by default, that'd eliminate the possibility of
accidentally overwriting. I also want to eliminate the default
next/previous/first/last controls on the form. Only new data should be
possible.
Click to expand...

Set the form's DataEntry property to Yes. This will allow only new records
to be entered.
Secondly, can I create an "Abort" button that will close the form
without saving the current record?
Click to expand...

You can create a command button with the Event code of Me.Undo
That will Undo any changes made to the record.
 
Back
Top