Run a Macro After A FormOpens

[Ron A.]

Hello,

I am new to macros and need assistance in running a macro after a form opens.
I currently have a msgbox warning that opens when Access is opened. I would
like to have it run after Access opens with the form I have selected in the
database properties.

The reason for this is because our software has been modified to disable the
macro security options. When I use an AutoExec for the message box, you have
to close it twice... once when access opens and then again after you select
to allow macros.

 

[Steve Schapel]

Ron,

You can put the macro on the On Open event property of the form. Change the
name from AutoExec to something else.

What version of Access are you using?

 

[Ron A.]

2007
--
Aloha,
Ron A.

Ron,

You can put the macro on the On Open event property of the form. Change the
name from AutoExec to something else.

What version of Access are you using?

 

[Ron A.]

I believe what is happening, is that the form is opening initally and Access
blocks all macros while waiting for user input to accept. Once selection has
been made the form is closed and reopened with macros enabled. Because the
form is opened twice the macro is ran twice. Any suggestions around this?

 

[Steve Schapel]

Ron,

Is the database in a Trusted Location?

 

[Ron A.]

Yes
--
Aloha,
Ron A.

Ron,

Is the database in a Trusted Location?