Exit Switchboard Form to Access Database

J

J

I created my own menu, instead of using the switchboard. This form opens
upon opening the database. I added a button to exit the menu (form) and want
it to open the database, however, it will only close the form and leave me on
a blank screen. What code do I add to take me to the regular database
screen? The database name is "Patent".

Private Sub ExitMainMenu_Click()
On Error GoTo Err_cmd_ExitMainMenu_Click

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "frm_StartMeUP"
DoCmd.Close acForm, "frm_StartMeUP"

Exit_cmd_ExitMainMenu_Click:
Exit Sub

Err_cmd_ExitMainMenu_Click:
MsgBox Err.Description
Resume Exit_cmd_ExitMainMenu_Click

End Sub
 
A

Allan Murphy

Check the tick boxes in Tools Startup
Display Database Window should be ticked
 
J

J

Allen,

That option will Display the Database Window upon opening the Database. I
want the switchboard to open, but the option to exit the switchboard to the
Database Window.

Thanks,
J
 

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

Top