I have several forms I have set to maximize (I left them maximized and to be certain I also added docmd.maximize to the load event.)
Example: When FormA loads the first time, it is maximized. However, when FormB loads, then closes, FormA is no longer are maximized.

So far, I have tried using the same line of code in the gotfocus event of formA. But gotfocus for FormA is not firing when I close out the FormB.

Does anyone have any ideas on this one?
Thanks,

Loralee

Put the code on the On Close event of FormB


mmcdonal

I'm currently using docmd.maximize to maximmize the current form. How do I get it to maximize a different form?

Thanks,

Loralee

This same thing has happened to me many times. I have found that if I have a form and turn off the min, max, and close buttons on it, that the form behaves the way you describe. What are your form settings for min, max, close, nagivation, record selector, etc.?

Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division

Hi Greg,
That is exactly what I'm doing. I have turned off the min, max, close and navigation buttons, as well as record selectors. And my database window INSISTS on being partially opened when I open Access, no matter how many times I maximize and save it. I've been up and down the property sheet and into Help and every reference book I have.
How have you solved it?

Thanks,
Loralee

The way I solved it was to keep the min, max, and close buttons turned ON. When I did that, the form maximized properly.


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division

Hi Greg,
I was a little afraid you might say that when you pointed out the association you discovered. That may be what I end up having to do. So how have you prevented users from minimizing forms and getting them in a goofed up order? Or has that just not been an issue for you?

Thanks-
Loralee

My personal rule of thumb is that I never have more than one form open at any time for data entry; and I always turn OFF the "Display Database Windows" under TOOLS > STARTUP. If for some reason I do need a second form open for supplemental data retreival or entry, the second form is a pop-up modal. At that point, the user must finish work on this second form and close it before the first one is accessed again.

In the case of a switchboard, I DO have two forms open at once (the active one and the switchboard). The possibility is there that you mention, but most users are savvy enough not to minimize. If they do it, the know after that first time that it's not a good idea.


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division

Those are good rules for using forms. I do close the switchboard when another form opens, though, and the On Close event of every form is to open the switchboard.

BTW, I never use the switchboard wizard, but create my own main forms.

mmcdonal

Thanks, guys. I'll play with toggling visibility of the switchboard first before closing it completely (i have code that calls a .dll to tend to the mousewheel that has to be available while the app runs that i've been stashing in the main switchboard form. The database window is only available now for my convenience while I build. It's probably time to not display it.)
Are you aware of any weird things Access does with invisibile forms?

Thanks for your time,

Loralee