I've created a large Access 2000 MDB with a number of forms (tables, queries, modules and reports). All of the forms have VBA.
Recently, after I made a modification to the VBA on one of the forms, I received the standard Access query of "Do you want to save changes to the design of form 'XXXXX' ?" along with the 3 options of Yes, No, and Cancel. I selected "Cancel" because I remembered another change I wanted to make to the VBA. After I made the change to the VBA and attempted to save again, I received the message, "You canceled the previous operation" accompanied by an OK button. Multiple clicks on the OK button eventually made the message go away, but now I can't make any changes to the form, even if I close the database, application, and Access and restart them. I always get the same error message following an attempt to edit the VBA of the form and save it. Also, I can't delete the form in question.
I searched the Microsoft site but can't find any help. I've tried the Access repair option with no success. What the heck is going on? Any suggestions on how to fix or restore the forms in the MDB?