How do I turn off auto save? I don't want the form to automatically save as I move from form to form. I want to be prompted to push the "save" button. Thanks.
As Pat's links will show you...you must use the forms BeforeUpdate event. You might be interested in how I use the event to prevent my users from moving to another record or from closing the form unless they use my custom save button. Check out this link... http://www.access-programmers.co.uk/forums/showthread.php?t=38364&highlight=mouse+trap