Minimize on open

[Chad]

hello, When I open my DB I want a form to minimize and one to stay open. Im
using

DoCmd.OpenForm "frmSlitterSetUp"
DoCmd.Minimize

To minimize the other form but my problem is if the minimized form is
minimized and I minimized the entire DB and then maximize the DB then the
form that was minimized is now open as well instead of the way I left it. How
do I fix this? Thanks!

 

[Jeff Boyce]

Another approach might be to use something like (untested):

DoCmd.OpenForm "YourFormName",,,,,acHidden

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Chad]

It doesnt work. I tried it and when I open the form it hides the other on
untill I open it with a button. Even so when I minimize the DB and open back
up it still does the same thing? Thanks!

 

[Jeff Boyce]

Chad

I guess I'm not understanding your situation...

I use a startup routine for many of my applications that opens one form
hidden (it keeps track of when the application gets shut down) and the next
form normally. This approach has worked so far for me.

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Chad]

Ok Jeff here is what I want to do. When the app opens I want the frmMain to
open and be on top and at the same time whe the app opens I want a form
called frmSlitterSetUp to open and be minimized not hidden. That all work but
if I minimize the app and maximixe it then the form frmSlittSetUp opens up
and is on top of my frmMain instead of still minimized? Hope I explained this
better.... Thanks!

 

[Jeff Boyce]

You appear to have decided "how" you will do this. Good luck!

(or you could re-read my suggestion to see if there might be another way to
get the job done...<g>)

Instead of opening the form minimized, try opening it hidden.

Regards

Jeff Boyce
Microsoft Office/Access MVP