Rocky Smolin
rockysmolin at bchacc.com
Sun Dec 25 12:10:44 CST 2011
Dear List: I have a form in an Access 2003 app exhibiting some odd behavior. The form is bound to one table. When anything on the form is changed, the form seems to lock - that is, you cannot move to another record using the navigation buttons. Before making a change, the navigation buttons work. I put a 'Save' button on the form with the one line in the click event DoCmd.RunCommand acCmdSaveRecord which generates the unhelpful error 'Run Time Error 2501 - The RunCommand action was canceled.' If I put 'DoCmd.RunCommand acCmdSaveRecord' in the dirty event, it saves the record but the navigation buttons are still not functional and I can't go to design view. Further, clicking 'View' and 'Design View' does not work at this point. I have to click the 'Exit' command button on the form or File-->Close. If I use the close button of the form I get a message "You can't save this record at this time." although the record was saved because I added 'DoCmd.RunCommand acCmdSaveRecord' to the dirty event. To eliminate the possibility that my installation of Access on this machine got hosed, I moves the app and back end to a second machine and got the same results. I would prefer not to use the save on the dirty event because I have an undo button that the user likes. But I think if someone can lead me a solution of the navigation button thing, this will solve the save problem. Any ideas? I'm stumped. MTIA Rocky Smolin Beach Access Software 858-259-4334 www.bchacc.com <http://www.bchacc.com/> www.e-z-mrp.com <http://www.e-z-mrp.com/> Skype: rocky.smolin