I have a form with an OnLoad event procedure. The form works correctly in the folder in which the accdb was created, and in some other folders on my hd, but when I copy the accdb to my desktop and to some other folders on my hd the OnLoad procedure does not fire. For testing I inserted MsgBox "Open" as the first line in the procedure and also set a breakpoint on the procedure name line, but the procedure is bypassed entirely in some folders but not in others. I have tried compact/repair and decompile, but neither fixes the problem.
This is an app I intend to distribute to others, so I need to make sure it is going to work everywhere - does anybody have any suggestions?