Forms behind???

[TOPSie]

My Access (2016) application has several “Main” screens and many further “Information” screens.



But consider this situation – Two Mains screens M1 and M2, two Information screens A & B. A has a SubForm embedded (Asub)

From M1 I can open form B using acDialog
Once on Form B I can click a control and open form A using acWindowNormal.
Both A and B appear on the screen side by side and I can close either without affecting the other.

However from M2 I open form A using acDialog and then using a control in Asub I try and open Form B using acWindowNormal then Form B is nowhere to be seen – it is actually there but behind M2 and only appears when I close both A and M2.

I don’t understand why both A & B are visible in the first case but not the second. Is it to do with subforms or something else??

[Micron]

Never have experienced. What I'd start with is ensuring all relevant form properties are the same, even borders. If that all looks OK then perhaps use code to control the position of both forms in both situations using MoveSize method. It might be due to one form having a subform as you say. One thing I can point out is that if you save a form while it's in a position, Access remembers that position next time you open it. Perhaps you did that and have inadvertently set its horizontal/vertical position to be somewhere you don't want. That doesn't apply to tabbed form views of course.

[TOPSie]

Is it to do with subforms ??

No it is not to do with sub Forms. I move the "open other form" code to the main form of A with the same result.

I also found some code using

Public Declare Function BringWindowToTop Lib "user32" _
(ByVal hwnd As Long) As Long

Which again had no effect as B is still behind the Main form


I am not sure it is anything to do with the way the Form is saved (as in the other answer) as forms A and B are unchanged and if I go M to B to A it works, but the other way it doesn't - same forms just a different order.

Ho hum

[Micron]

Suggest you copy, compact/repair, zip and post here. See top forum menu for how to attach files if needed.
I think this is going to be pretty difficult to solve otherwise. You can remove whatever is not needed for the issue and/or alter data as per here.