Overide tab-through Autosaving?

[Eyor]

I have a form with several sections which corrrespond with different tables. Currently, when a user clicks or tab's through to the next section, the previous section is automatically saved into the corresponding table. Is there any way to over-ride this automatic saving and have the form be saved all at once? The autosave has been a real nuissance as the records created cannot then be deleted without cascading (very few users have rights to cascade delete). Hope this is clear, please let me know if I need to expand.

 

[ghudson]

Sounds like you might need to use an unbound form. That would require a lot of extra work and programming your form and all the subforms within. The BeforeUpdate event is the only event that will let you prevent the saving of the current record. Search around for there are lots of postings related to the forms BeforeUpdate event.

 

[Eyor]

Thanks very much! Found just what I needed on this thread http://www.access-programmers.co.uk/forums/showthread.php?t=74847&highlight=BeforeUpdate+event+save . Looks like you've done quite a bit of work on this. Much appreciated.

 

[Pat Hartman]

Simply tabbing through a form should not cause it to save since tabbing doesn't dirty the record. You must have code running in the wrong events and that is causing the records to be dirtied. If you fix your code, your problem should go away.