Don't want data automatically saved, want to confirm before saving

[chablups]

The default on a form is to automatically save as you enter data. I don't want that. I want to be prompted to confirm before saving data. Can I change the default setting for this?

 

[Jack Cowley]

You can't change the default settings but there are a number of ways to do what you want. I would suggest searching these archives as this question has been addressed numerous times. Also search the MS Knowledge Base for additional articles.

 

[chablups]

Thank you Jack. I have now searched the archives for several hours. Found two solutions, the first one does not work, and the second one, something about creating a "global module" was too vague for a nubee like me to know how to do it. Isn't there some relatively simple way to turn off the autosave, or establish a way around it?? If I don't get some help soon, my next call is to Microsoft Tech support and there goes $35!

 

[MrTibbs]

One suggestion:
Ensure your table has a unique key, copy the records you want to edit into a temporary table. Present the temporary table in the form and on closing the form and confirming the save use a query or 2 to update the original table.
You have to validate each incoming line against what was there originally and only change or add what's altered and consider what would happen if 2 or more updates clashed