AutoExec macro

P

pm

I have an autoexec macro that runs with a condidtion = MsgBox("Are you ready
to run the Register and Bank Macro?",1)=1. This works great if I want to run
the macro everytime I open the database. I'd like to be able to cancel or
select no and not run the macro.....Any suggestions would be appreciated.
Thanks.
 
R

Ryan

Have a form that opens when the database opens instead of running the macro.
On the form have 2 buttons. One button runs the macro, the other button does
not run the macro and takes the user to another page. Then just label the
buttons to describe what the do. If you go to Tools, Startup you can tell
Access to open this form when the database opens.
 
P

pm

Thanks for the suggestion Ryan. But I'd really prefer to run the macro upon
opeining just have the option to cancel or say no.....
Your suggestion is a good alternative.
 
Top