I have a form that saves data after leaving the last field on the form. I understand that access will automatically save the data if the form is "dirty". I don't want this to happen. I want the user to decide to save the data by pressing the "save" button on my form.
This only happens when I either 'tab' out of the field or hit enter which in essense is tabbing out.
Can I set the field control to on dirty from true to false on exit from the field. If so, what if the user wants to cancel out and return to another form by pressing another button on the form? Also do I need to set this for each field on the form? Can I set it globaly? That is, I do not want any records saved on any form until the user presses the save button on that form.
Your help would be appreciated.