S
StargateFanFromWork
I have this as the opening 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.Maximize
' 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
****************************************
Initially, the DoCmd line above said "DoCmd.Minimize" which did minimize the
db window but left the switchboard as a normal window. So I just changed
that to "Maximize". Now, yes, the Switchboard opens up completely but so
does the db window. How can we have one without the other, i.e., minimize
db window yet maximize switchboard?
Thank you.
****************************************
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.Maximize
' 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
****************************************
Initially, the DoCmd line above said "DoCmd.Minimize" which did minimize the
db window but left the switchboard as a normal window. So I just changed
that to "Maximize". Now, yes, the Switchboard opens up completely but so
does the db window. How can we have one without the other, i.e., minimize
db window yet maximize switchboard?
Thank you.