Access 2007, Code will not run when DB first opened?

[purplefern]

I have a database I created with access 2007 and saved as a 2003 mdb. When I open the file everything seems to work until I click on any of the buttons, then I get an error 'Return without GoSub'. All of the buttons do this until I open the code window, then everything works like it is supposed to. Why is this happening and how can I fix it? I need to put this on another computer and I don't want the user to ever open the code window.

 

[Remou]

Possibly security, have you self-certified the project?

http://office.microsoft.com/en-us/access/HP010397921033.aspx

 

[purplefern]

Thank you for the link, I have read it and went back through all the settings to make sure something did not change in my security settings since I started testing and I did not find anything out of order.

I have moved everything to a trusted source folder and even lowered the security setting but I still get the same problem. I have not ever received the notice that anything has been blocked with this DB although I have received that message while opening other DB's from different sources.

This problem only started a week ago and before that everything worked as expected. There were no major changes to the DB or the code before the problem popped up.

 

[Remou]

How about this?

http://www.eggheadcafe.com/software/aspnet/30942154/return-without-gosub-erro.aspx