 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms / May 2008Saving changes to a form
I have added a field to a previously created form but I can not save the change. I close the form and I'm asked if I want to save changes and I click yes. The form will not close and this just repeats everytime I try to close. Any suggestions? Thank you. First, make sure your form is editable (has the arrow and asterisk at the bottom.) If your form is not editable it won't let you add data. If your form is not editable, the query or table it is based on is not editable. Second, if your form is editabel, add a command button to the form. Use the command button wizard and select form operations/save form. Even though the form should save without the command button, I always put it on there anyway so the users will make sure their data is saved. > I have added a field to a previously created form but I can not save the > change. I close the form and I'm asked if I want to save changes and I click > yes. The form will not close and this just repeats everytime I try to close. > Any suggestions? > > Thank you. >I have added a field to a previously created form but I can not save the >change. I close the form and I'm asked if I want to save changes and I click >yes. The form will not close and this just repeats everytime I try to close. >Any suggestions? > >Thank you. Try opening the form *just in design view* - i.e. don't open it with data at all. Make the change and save it. My guess is that you have some VBA code in the form's Close or BeforeUpdate event which is causing the problem - do you have anything in those Event properties? if so please post the code.  SignatureJohn W. Vinson [MVP] I have nothing in the event properties. I have been playing around with it and it will not save even if when no changes made. I have to select no when asked if I want to save it. > >I have added a field to a previously created form but I can not save the > >change. I close the form and I'm asked if I want to save changes and I click [quoted text clipped - 9 lines] > event which is causing the problem - do you have anything in those Event > properties? if so please post the code. >I have nothing in the event properties. I have been playing around with it >and it will not save even if when no changes made. I have to select no when >asked if I want to save it. This makes NO sense. What specific steps, click by click and keystroke by keystroke, are you taking? SignatureJohn W. Vinson [MVP] John, I open the form in design view. Click "add existing fields". Select the field I want and drag to the form. I select save and it appears to save but when I close the form it asks again if I want to save and then repeats from there. Let me add that the form is a subform but I'v never had issues before. I am also running office 2007. Thanks > >I have nothing in the event properties. I have been playing around with it > >and it will not save even if when no changes made. I have to select no when > >asked if I want to save it. > > This makes NO sense. What specific steps, click by click and keystroke by > keystroke, are you taking? |
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.