Maxmize Main Form... and ONLY main form...

[Woodman650]

Hey guys,
I'm having a problem maximizing a form... the form opens automatically when the DB does and maxmizes using this code:

Private Sub Form_Open(Cancel As Integer)
DoCmd.Maximize
Dim i As Integer
For i = 1 To CommandBars.Count
CommandBars(i).Enabled = False
Next i
End Sub

but when I open up any other forms from that form, they maxmize too. When I close them to get back to the main form, the main form is no longer maximized. any ideas? thanks!!

 

[ZmrAbdulla]

You can do it in GotFocus, OnActivate Events of the form. "DoCmd.Echo..." to stop flickering the screen.

DoCmd.Echo False
Docmd.Maximize
DoCmd.Echo True

________________________________________________________
Zameer Abdulla
Help to find Missing people
Sharp acids corrode their own containers.