Switchboard form not opening

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

Guest

Hi. I'm using a switchboard (the one from the Contacts database). It works
fine on one of my databases. But on a new one I created, when I open the
database, the main Access screen minimizes but the Switchboard form doesn't
open. If I expand the main Access screen and select the Switchboard form,
all is well (the main Access screen minimizes and the Switchboard opens).

The code for the Switchboard is the same on both databases. I made sure
that my references were the same and in the same order. I appreciate any
suggestions.
Here's the form open code:
Private Sub Form_Open(Cancel As Integer)
' Minimize the database window and initialize the form.

On Error GoTo Form_Open_Err

' Minimize the database window.
DoCmd.SelectObject acForm, "Switchboard", True
DoCmd.Minimize

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

Form_Open_Exit:
Exit Sub

Form_Open_Err:
MsgBox Err.Description
Resume Form_Open_Exit

End Sub
 
Geez! Thanks. That was it. It never pays to slack off from Access as I
forget the little I ever knew!
I appreciate that you share your talents and are always kind in your replies.
--
Thanks for the help!



Jeff Conrad said:
Does one of the databases have the Switchboard form
set to open when the databases opens and the other
does not?

Specifically:

Tools | Startup | Display Form (name of form listed)

--
Jeff Conrad
Access Junkie
http://home.bendbroadband.com/conradsystems/accessjunkie.html
http://www.access.qbuilt.com/html/articles.html

in message:
Hi. I'm using a switchboard (the one from the Contacts database). It works
fine on one of my databases. But on a new one I created, when I open the
database, the main Access screen minimizes but the Switchboard form doesn't
open. If I expand the main Access screen and select the Switchboard form,
all is well (the main Access screen minimizes and the Switchboard opens).

The code for the Switchboard is the same on both databases. I made sure
that my references were the same and in the same order. I appreciate any
suggestions.
Here's the form open code:
Private Sub Form_Open(Cancel As Integer)
' Minimize the database window and initialize the form.

On Error GoTo Form_Open_Err

' Minimize the database window.
DoCmd.SelectObject acForm, "Switchboard", True
DoCmd.Minimize

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

Form_Open_Exit:
Exit Sub

Form_Open_Err:
MsgBox Err.Description
Resume Form_Open_Exit

End Sub
Click to expand...
Click to expand...
 
in message:
Geez! Thanks. That was it. It never pays to slack off from Access as I
forget the little I ever knew!
Click to expand...

In the medical community this is called the Conrad Syndrome.
;-)
I appreciate that you share your talents and are always kind in your replies.
Click to expand...

Thank you for the kind words, I enjoy helping.
:-)
 
Back
Top