I have been getting an error in my database when a user clicks on a button that has an on click event. I am using DoCmd.OpenReport and the code works fine. However, sometimes I get the following error
If i go into design mode, then open the vba editor and then close it --WITH NO EDITS OR CHANGES-- then the buttons start to work.
I have tried to compact and repair but when I open the database back up i get the same issue.