Open Form On Close

P

PaleRider

Hi,

I want to be able to open a form "Inventory" in maximized state when another
form "Features" is closed. Currently when I have form Inventory open and
click a button to open form Features, when Features is closed my Inventory
form looses it's current state and switches to a state that is not maximized.
In other words, I want my Inventory form to stay maximized irregardless of
what any other form is opened and closed.

Is there a way to make this happen?

PR
 
P

PaleRider

I found a way to keep my main form maximized irregardless of whether I open
another form or table. In my main form's On Activate properties I just added:

DoCmd.maximize

Since all other forms tables are opened from my main form "Inventory", upon
closing the other forms/tables the focus shifts back to "Inventory" and the
On Activate property kicks in and executes the DoCmd.maximize event. It
works so well you can't even tell anything changed at all.

PR
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

If statement at open of Form? 1
open form NOT maximized 2
open form in maximized state 2
Main form won't stay maximized after a report closes 3
Switchboard restore down coding Office 2007 1
open form maximize 2
Open Form using Form with MsgBox Error Response 10
form size 3

Top