Startup

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

Guest

Hi all ,

I have to forms,I'd like to use one of them,according to the users choice,
as the startup for my database.
I have another form called "Startup",that contains 2 check boxes ,to
switch between the two eligible startup forms.
Which code should i write in each check boxes to select the suitable form
as start up ?
 
Are you using an OptionFrame containing the 2 CheckBoxes or are these
independent CheckBoxes?
 
Click on menu HELP and type in switchboard. Read how to use the switchboard
and switchboard manager.
 
Assuming:

* The 2 CheckBoxes have values 1 and 2 respectively (the OptionFrame will
take on 1 of the 2 values according to the selection by the user).

* You have a CommandButton to open the required Form on the StartUp From:

, you can code the CommandButton_Click Event something like (untested):

********
Select Case Me.fraSelection
Case 1
DoCmd.OpenForm "FormForFirstSelection", ...
Case 2
DoCmd.OpenForm "FormForSecondSelection", ...
End Select
********
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access: Combo box switching btw multiple back ends? 1
Startup Problem 4
switchboard startup in Access 2007 1
Text box don't show information 4
Startup form changing unexpectedly. Why? 3
Where have all my tables,forms, reports gone? 5
Where is the startup manager in 2007 2
Multiple Select List Box as a Parameter? 10

Back
Top