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.
Overide tab-through Autosaving?
- Thread starter Eyor
- Start date
ghudson
Registered User.
- Local time
- Today, 16:41
- Joined
- Jun 8, 2002
- Messages
- 6,193
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.
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.
Similar threads
