Problems with Access popup forms disappearing behind the main form

Hello All

I created a bunch of forms for an Access database I created.  This problem does not happen all the time but when it does I have to shut down the whole Access program and restart it, losing what I did.

I have a Main Form that is maximized to take up the entire screen.  When a user clicks on a button a smaller form pops up in front of the Main.  Now most of the time this works fine, but ever so often the Popup Form blinks and then is behind the Main Form (the way I know this is when I right click on the Access icon on the toolbar and choose close the Main Form disappears and the Popup is on the screen briefly as the whole thing shuts down).

The Popup Form is set as Popup Yes and Modal Yes.  

Here is the line I use on the Main Form to call the Popup - DoCmd.OpenForm "Popup Small Quote Type Add", , , , , acWindowNormal

I cannot use acDialog to open the Popup because the users to not like the way it looks.

Help! :D

Thanks
alevin16Asked:
Who is Participating?
 
crystal (strive4peace) - Microsoft MVP, AccessRemote Training and ProgrammingCommented:
the forms are layered then -- so if someone clicks the main form, it will come to the front.  Perhaps save the forms so the little one opens in the upper left corder and the main form slightly off that so the little one will always have a part of it showing. And perhaps when the little one opens, restore the view.

The properties may be being overridden by opening it as normal.
0
 
Gustav BrockCIOCommented:
Double-check this:

The Popup Form is set as Popup Yes and Modal Yes.  

because - by definition - there is no way to get a modal form behind another form - except for popping a new modal form.

/gustav
0
 
alevin16Author Commented:
Hey Everyone

Thank you all for the advice!  I took your advice gustav and I did do a doublecheck to see if they were set right and they were so I am wondering if there is some sort of odd bug in Access.  

I think I am going to have to try the first idea from Crystal of the Main Form not staying maximized and moving it slightly so that both forms can be gotten to.  I am not a big fan of that (I guess I am just anal and like the Main Form fully maximized) but if it keeps the users from having to shut the program (and of course yell at me :D) then I will do it.

Andy
0
 
alevin16Author Commented:
Great comments as always from the experts!
0
 
crystal (strive4peace) - Microsoft MVP, AccessRemote Training and ProgrammingCommented:
you're welcome ~ happy to help
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.