Switchboard Issue - Opening a Switchboard Subform Manually

[mohsinhq]

Hi Guys,

I've checked the search but cant seem to find any answers relating to my problem. Apologies if ive missed it.

What i need to do seems fairly straightforward but unfortunately i dotn have the knowledge to pinpoint what has to be done.

I have a switchboard with several sub switchboards. I need a button on a normal form to move to a sub switchboard bypassing the main switchboad menu..

Is this possible?

Thanks in Advance

 

[Ron_dK]

I generally would not recommend to use the switchboard at all. I would suggest to make a form and add buttons to it.

Anyway, this might be a way to switch from a form to your "subswitchboard.

Go to your subswitchboard and open it in the design view. In the form properties, see what the form is called under Caption ( e.g. Addressbook)

The On Click event procedure of your button on your normal form should
be something like :

Private Sub cmdViewResults_Click()
On Error GoTo Err_cmdViewResults_Click

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "Addressbook"
DoCmd.OpenForm stDocName, , , stLinkCriteria

Exit_cmdViewResults_Click:
Exit Sub

Err_cmdViewResults_Click:
MsgBox Err.Description
Resume Exit_cmdViewResults_Click

End Sub


Hope this helps.

 

[mohsinhq]

A switchboard doesnt create seperate forms for each sub menu. Its always the same form but with the options available changing...

This is the problem in that if i open the swicthboard it always refers to the main menu and not the sub menu i want it to refer to

 

[PARSO]

if i read this right, thats why you should create your own, menu form, that will allow you to have as many 'sub-forms as you want, and will place them individually, so a button on a normal input form can go to a subform withiut the user seeing the main form.... if that makes sence?

 

[Ron_dK]

A switchboard doesnt create seperate forms for each sub menu. Its always the same form but with the options available changing...

This is the problem in that if i open the swicthboard it always refers to the main menu and not the sub menu i want it to refer to

If you intend to stick to the Switchboard, you'll need to add something like this on the button in the other form :


' Move to the switchboard page that is marked as the default.
Me.Filter = "[ItemNumber] = 0 AND [Argument] = 'Default' "
Me.FilterOn = True


The itemnumber is the corresponding "button" on your switchboard.
Take a look at the Switchboard Items table to identify the appropriate itemnumber and/or SwitchboardID.