Form does not retain it's size

[akar33]

I have one main form from where user makes the initial selection, upon selection (clicking a button to open another form), when the user closes the second form the initial form looses it's size, I want to stay maximized, How can I acheive, I tried onLoad (Maximize macro) then I tried Onload Docmd.Maximize

None of then seem to work the moment the second form is closed the initial one goes back to smaller size.

Let me know how to get around it.

 

[AlexMidd]

Try On Activate or On Current.

Have fun! )

Alex Middleton

 

[BuilderSpec]

When you open the second form you could try opening it with the acDialog set , then when the code returns do the maximize then

DoCmd.OpenForm "Form2", , , , , acDialog

DoCmd.Maximize



Hope this helps!

Regards

BuilderSpec