I have an Access 2002 db. It has a wierd problem. I have created a menu, which loads a form, the form in turn references a class module.
I open the db, click the menu, all is OK, the form opens. If, I then go into design mode, exit design mode then re-click the menu, I get Error 5.
Even stranger, this happens on my PC and one other I tried it on. However, if I try this procedure on 3 other PCs, no error is reported, everything is fine.
I have checked all the references, they are fine, and versions across the PCs all the same. I have re-installed Office XP on my PC, still get the error.
I'm convinced its not a coding issue, more an environment, but I'v run out of ideas if things to check. Any ideas ?