Auto EXEC Macro Error

[nebula53]

Please find the attached Data base

When I changed the design of the Main form the macro stopped working properly

How can I fix it so when I open my Data base the ( Main form ) open automatically as the interface of my Data base.

[gershwyn]

Nebula - You might find you get a better response if you can post the code used in your macro (as well as any used in your form) as well as posting the details of the error and the circumstances that cause them.

Some users might be wary of downloading a zip file, especially considering you haven't told us what format it's in.

[mshmyob]

It worked for me when I opened it. It automatically opened the Main form. Is it supposed to do anything else?

cheers,

[missinglinq]

Did you also move the file, perchance? In Access 2007/2010 macros, like code, won't run unless the folder holding the file has been declared as "trusted." If you move a file from a trusted folder to one that hasn't been declared as trusted you'll get this error.

Of course, if all you're doing is having the main form open when the database does, you can go to

Tools-Startup

and set it in the Display Form/Page box. Not sure where you'll find this in versions 2007/2010, but Access help should be able to tell you.

Linq ;0)>

[nebula53]

Thank you guys, I appreciate your responds and advises.