When report Minimized, forms shift downwards...?

[and]

Hi - what do I need to do to stop this happening..?

Button opens a report from a maximised form. When the rpt is open, when I minimize it (which I'd like to be able to do), the form(s) open behind it have shifted down about have a screen (not minized) just moved. How do I keep my forms maximised in the window?

TIA
Andrew.

 

[mph1]

Try entering the following in the report, design view, OnClose

Private Sub Report_Close()
DoCmd.OpenForm "FromName", acNormal
DoCmd.Maximize

End Sub

Something else you could do is to close the form before opening the report.

HTH

An investment in knowledge always pays the best dividends.
by Benjamin Franklin
Autonumber Description - FAQ702-5106

 

[PHV]

Simply in the Activate event procedure of your form, add the following line of code:
DoCmd.Maximize

Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[mph1]

PHV is correct. What I had done is to add, before the line of code DoCmd.Maximize , which would return you to a specific form. It could be from the last form or some other specific form.

An investment in knowledge always pays the best dividends.
by Benjamin Franklin
Autonumber Description - FAQ702-5106

 

[and]

Hmm. Thanks Guys. Tried putting DoCmd.Maximize in the Activate property of my form, but it still happens.
My question might possibly have been misleading.

The form with the buttons is a 'Menu' form. I want this to be always Maximized and at the 'back' so that it is always filling the screen whenever my user closes whatever else is open.

The prob happens when I open Report from a button on this form, and then minimize this report - the Menu form that was open behind is then shifted half way down the screen. The user has to then manually maximize this menu form.

What's amiss?

 

[PHV]

Activate property
???
And what about the Activate (b]event procedure[/b] ?

Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[and]

Ah yes. Gotcha.
Sorry...mistake..
Does what I tell it to do now!

Thanks alot.
A.