 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms / March 2007Saving Form Info
Hello - I have made a form that MANY people will be using. Can I make the form not write to the table until they hit the save button? I'm trying to prevent them from entering have the data and then X out, which would make quite a mess. I would like to set it up with a delete button, and they can delete the whole form w/ that. Basically, I would like nothing actually effects the stored data until they hit save. I could do it with temporary tables, and have a query to delete the temp and write to the permentant, but I have six subforms on the main form and I'm sure there is an easier way. Thank you so much for all your help!!!!!! Katelin In the Click event for the save button, set a form-level boolean flag that indicates the button was clicked. Then in the Form_BeforeInsert and Form_BeforeUpdate events you can check to see if the flag is set. If it is, allow the Subs to proceed (do nothing). If it is not, set the sub's Cancel parameter to True to cancel the Insert/Update. Carl Rapson > Hello - I have made a form that MANY people will be using. Can I make the > form not write to the table until they hit the save button? I'm trying to [quoted text clipped - 6 lines] > I have six subforms on the main form and I'm sure there is an easier way. > Thank you so much for all your help!!!!!! Katelin Can you explain this a little more. What is "set a form-level boolean flag?" Also, which form would I do the BeforeInsert and BeforeUpdate events on, the main form, or all of them? Thank you so much for your help. > In the Click event for the save button, set a form-level boolean flag that > indicates the button was clicked. Then in the Form_BeforeInsert and [quoted text clipped - 14 lines] > > I have six subforms on the main form and I'm sure there is an easier way. > > Thank you so much for all your help!!!!!! Katelin |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.