There's this program written by VBA running in Access. Every time we enter some data on a form and press the next record button on navigation bar data is saved automatically. I would like to know if there's a possibility to change this behavior, for example, to ask the user before saving the data.
+1
A:
It may be possible to use the before update event for the form with cancel and undo, but it is by no means infallible.
If there is some problem with data entry, do not think that asking will help, I have tried "Are you sure?" before, and the user gets into the habit of clicking yes automatically, followed by "oops".
Remou
2010-08-05 09:24:27
Remou, yes, I'd agree with that behavior. Far better to give them a means of being able to update things.
Tony Toews
2010-08-09 19:48:00