Maximised Form de-maximises after closing Dialog Form

[BiigJiim]

Hi,

I am using Access 2010, but this is a problem which I have noticed going all the way back to Access95.

I have a form (lets call it frm1) which opens maximised. A command button opens a second frm2, also maximised. If I close frm2, frm1 stays maximised. All good. But I have a 3rd dialog form, which opens as a popup form, which is sometimes opened from frm2.

Using vba, If I close frm3, frm2 stays maxmised. All good. However, if I close frm2 and then frm3, frm1 becomes de-maximised (i.e. restores to a window). The odd thing is that if my vba closes frm3 before frm2, then everything is ok and frm1 stays maximised. There is no other code or anything which sends does a docmd.restore or anything like that

My form settings are as follows:

frm1 & frm2:
Popup NO
Modal NO
AutoCentre NO
AutoResize YES
Border Style Sizeable
Control Box YES
Close Button YES
MinMaxButtons BOTH ENABLED

frm3
Popup YES
Modal YES
AutoCentre NO
AutoResize YES
Border Style Dialog
Control Box NO
Close Button NO
MinMaxButtons BOTH ENABLED

I have tried messing around with these settings, but nothing seems to help.

In vba, all forms are opened using docmd.openform and using the default acWindowNormal

Can anyone help? This is a major frustration!

Many thanks,
Jim

 

[burrina]

Try If IsLoaded and also SetFocus and see if that helps.

 

[BiigJiim]

Hi Burrina, apologies for taking so long to reply to this.

Yes, I can always use IsLoaded to detect the form and re-maximise it, but the point is, it shouldnt be necessary, and having forms continually restore and maximise makes for a clunky user experience.

Anyone else ever experienced this? It has always happened to me, under multiple generations of Access, so I can't believe this is an isolated experience!

Thanks,
Jim