Switchboard Question

[J. Trucking]

Hello All,

I have a quick question about switchboards. I have used access before
but am not sure how to proceed with the following. When my database
opens, the switchboard is displayed first. What I would like to have
happen, is the main categories for the database would be displayed on
the left side of the switchboard. When the user clicks on one of
these main options is clicked, the sub-options appear in the center of
the switchboard. What I have typically done in the past is create new
forms for each main option so when the user clicks, a new form is
opend . Can this be done with one form or do I need to create many
forms?

Thanks in advance,

John

 

[Guest]

Unless I'm wrong I only believe the sub-options can only appear in new forms.

I'm assuming you are using the Switchboard Wizard.

I hope this helps

 

[Len Robichaud]

Are you using the MS Access Switchboard utility? Or are you referring to
your own Main Form as the "switchboard?
If it is the latter, you could create all of the possible buttons (Primary
and Sub options) on the Main form (make sure you name each button something
meaningful such as btnMain1, btnMain2 and btnSub1, btnSub2, etc).
Then set all of the "Sub Option" button properties to visible = False. This
will make these buttons invisible when you start the form.
Then on each of the Main buttons go to the ONCLICK event property and write
a few lines of code setting all of the desired btnSubs to visible = True and
the Undesired btnSubs to visible = False.

Len