asked on

Access 2007 Form OnLoad event not firing

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?

ASKER CERTIFIED SOLUTION

Dale Fye

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

mbizup

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

dgmoore1

ASKER

You're both correct - I've been developing in Access since version 1 but for some reason the "Trusted Location" issue keeps slipping my mind. I don't get the "macro nag" on my development workstation, and, come to think of it, this won't be an issue for my users because the security settings on their network force them to enable macros/code each time they open any Access/Excel/whatever application that contains code. The users hate this, but security remains unswayed. Thanks!