Has anyone experienced their buttons (using macros) on a form working fine, then you come back to that form after doing some other actions in other forms and the buttons cease to work. Also clicking on the design view tool/button does not work. The only thing I can do is quit (and go to task manager and close the straggling file MSACCESS.EXE) and reopen the database, only to have it happen again after another several (and seemingly unpredictable) actions.
As far as telling the specific scenario, I wouldn't know where to start. Has anyone had this problem before?
Start your project while holding the Shift key down. Open a code Module. Go into the Debug Menu item and select Compile And Save All Modules. Most often its a code problem (bad declaration, System Key Words used, etc.). The above action usually finds the problem and points it out to you.