Exit Switchboard Form to Access Database

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
Back
Top