Cancelling entries

[Guest]

The forms on my current database are linked directly to the tables of the
database, and I have been requested to insert a cancel button onto the form
to cancel changes. This seems to be pretty simple with a simple form, but a
majority of the forms I use have a subform with the continuous forms view.
From what I have learned from databases, once you move on to the next
record, the changes made to the previous record are automatically saved and
cannot be cancelled or undone. Is there a workaround that will allow the user
the option of cancelling all the changes made in the subform as well?

 

[Rick Brandt]

The forms on my current database are linked directly to the tables of
the database, and I have been requested to insert a cancel button
onto the form to cancel changes. This seems to be pretty simple with
a simple form, but a majority of the forms I use have a subform with
the continuous forms view. From what I have learned from databases,
once you move on to the next record, the changes made to the previous
record are automatically saved and cannot be cancelled or undone. Is
there a workaround that will allow the user the option of cancelling
all the changes made in the subform as well?

Only if you bind your form to "work tables" and then use action queries to
move changes to the real tables when a [Save] button is pressed. A lot of
work for no real benefit in my opinion.

 

[JethroUK©]

a possible solution is to include a prompt in the before_update event of the
subform

aircode:

if msgbox "Do you want to save these changes?", vbYesNo = vbNo then cancel


although it's counter intuative to the way a database works - it will slow
down the trigger-happy



| The forms on my current database are linked directly to the tables of the
| database, and I have been requested to insert a cancel button onto the
form
| to cancel changes. This seems to be pretty simple with a simple form, but
a
| majority of the forms I use have a subform with the continuous forms view.
| From what I have learned from databases, once you move on to the next
| record, the changes made to the previous record are automatically saved
and
| cannot be cancelled or undone. Is there a workaround that will allow the
user
| the option of cancelling all the changes made in the subform as well?
|