Record saved every time a field is changed

[Maarten Voets]

When you change a record using a form (or directly in a
table), the record is supposed to be saved when you move
to a new record or close the form. When I use a form,
however, the record gets saved every time a change to any
of the fields is made, so before switching to a new record
or closing the form. This makes it very difficult to undo
changes made in a record. Does any of you have an idea how
this can occur and where setting for saving records can be
found?

Thank you for your help and best regards,

Maarten Voets
Amsterdam

 

[Scott McDaniel]

Users can hit "Esc" twice to remove changes before saving; you could also
try using the Me.Undo command (although this does not always work). If you
need full control of when and where your user data is persisted, you would
be better served by implementing an Unbound. In this, all textboxes are
unbound (there is no recordsource for your form), and you write code that
saves all data. It's time consuming, and it negates a lot of the positive
aspects of the Access environment, but if you must then you must.