Problems with Access popup forms disappearing behind the main form
Posted on 2016-09-30
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.