chablups
02-02-2002, 09:33 AM
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?
|
View Full Version : Don't want data automatically saved, want to confirm before saving chablups 02-02-2002, 09:33 AM 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 02-02-2002, 10:09 AM 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 02-02-2002, 10:38 PM 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 02-05-2002, 08:25 AM 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 |