Back to main(default) switchboard

[xtinct]

after i open a form using the switch board, i need to click a button to close the form and return back to the default switchboard.. what code do i need to put in the button to do the task?

 

[Rickster57]

close

Hope I am reading this right.
docmd.close

 

[2ippy]

Hope I am reading this right.
docmd.close

I've tried this code and it will exit all your database.

make a button and in properties, under the event tab.

On Click - select event procedure.

DoCmd.OpenForm ("form name")

 

[Rich]

DoCmd.Close acForm, Me.Name

 

[xtinct]

but closing the form only will bring me back to the sub switchboard.. i need to get back directly to the main switchboard

 

[gemma-the-husky]

are you using a standard switchboard wizard switchboard

if so you need an option in the switchboard items table with an action of 1, and an argument of 1 to get back to the main switchboard.

 

[xtinct]

if so you need an option in the switchboard items table with an action of 1, and an argument of 1 to get back to the main switchboard.

sorry.. i dont get what u mean by this

 

[xtinct]

ok.. solved the problem with

Form_Switchboard.Filter = "[ItemNumber] = 0 AND [Argument] = 'Default' "

 

[gemma-the-husky]

i meant, that if you used the switchboard wizard to create the switchboard - it creates a table called switchboard items

you can either re-invoke the wizard to manage your menu, but you can easily do it by editing the table directly.

you shouldn't need to enter the sort of code you did, as the switchboard manager the wizard designs handles all this automatically.