How to POP a Form when closing another one?

[jefferyzhong]

I want to start up with the instruction Form for my database, and when close it, I want the "Main switchboard" POP open.
could anyone tell me how to set the code!

thanks in advance!

Jeffery

 

[Remou]

Hi
How about something like (?):

Private Sub Form_Close()
    DoCmd.OpenForm "Switchboard"
End Sub

 

[TheAceMan1]

How are ya jefferyzhong . . . . .
[ol][li]From the database window, on the menubar select [blue]Tools[/blue] - [blue]Startup[/blue].[/li]
[li]In the [blue]Display Form/Page[/blue] comboxbox select your instruction Form and close out.[/li]
[li]In the [blue]Close[/blue] event of the instruction form, copy/paste the following ([blue]you![/blue] substitute proper names in [purple]purple[/purple]):

[blue]   DoCmd.OpenForm "[purple][b]SwitchboardFormName[/b][/purple]"[/blue]

[/li][/ol]

See Ya! . . . . . .