Switchboard form is opening but immediately gets minimized

[Guest]

I have a command button to open up the switchboard after login. But when I
login, the switchboard opens then minimizes automatically. How do I get it
to open properly?

 

[Guest]

Hi Tia

Open the form in design view.
Right click on the grey section of the form (below to space where you put
your buttons, box, lists, etc)
On the dropdown box select Event
Select On-Open
Click the build options (three dots on the right)
Select Code


You will see this



Private Sub Form_Open(Cancel As Integer)

End Sub



Insert one line of code (DoCmd.Maximize)

So that your code looks like this



Private Sub Form_Open(Cancel As Integer)
DoCmd.Maximize
End Sub



Click Save and close your form.
When you open it again it "should" stay maximixed.

Hope this helps

 

[Guest]

Thanks, it worked.
--
TIA

Hi Tia

Open the form in design view.
Right click on the grey section of the form (below to space where you put
your buttons, box, lists, etc)
On the dropdown box select Event
Select On-Open
Click the build options (three dots on the right)
Select Code


You will see this



Private Sub Form_Open(Cancel As Integer)

End Sub



Insert one line of code (DoCmd.Maximize)

So that your code looks like this



Private Sub Form_Open(Cancel As Integer)
DoCmd.Maximize
End Sub



Click Save and close your form.
When you open it again it "should" stay maximixed.

Hope this helps

 

[Guest]

Glad to help.

--
Wayne
Manchester, England.

Thanks, it worked.