Open a different form at startup

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form that is tied to a macro. The macro is names "AutoExec" so that
it runs automatically when the program starts up. I want the startup form to
change to another form if an option button is selected. Any possible way to
do this or manipulate an action to do this?
 
I really don't understand this one. How can you select an option button if
the database is not open yet? The only thing I can think of is that if you
click the button in the current session, then you want a different form to
open on startup from the next session.
If my assumption is correct, then you could have 2 marcos, 1 that starts
form A and one that starts form B. Then
use the Deleteobject method to delete the Autoexec macro.
use the Copyobject method to copy the macro you want to startup in the next
session with the destination name of autoexec.
 
your question is not really clear. do you want the user to choose an option
from the first form that opens, which then runs a macro to close that form
and open the selected form?

for instance, startup form shows two options: Data Entry and Reports. user
chooses Reports. the startup form closes and a Reports Menu form opens.

the above situation would have nothing to do with the AutoExec macro that
opens the startup form. you would set up a macro in the startup form itself,
to close the startup form and open the selected form.

if your scenario is different, you'll need to explain more fully just what
you're trying to accomplish.

hth
 
You rock, that works great. Now when I select an option button, the new form
will open up at start.
 
Back
Top