MS-Access Forms showing in background instead in front

[BertBruggeman]

Hello,

Our VBA MS-Access application uses forms.
Sometimes when a new form is opened, its appears behind the current open forms.
I googled about this and tried using BringWindowToTop and SetForegroundWindow, but so far no luck.
Anybody who knows why this happens, and if there is a solution?

[ranman256]

Is the current form (before you open the new one) in MODAL mode?

[Bob Fitz]

Sometimes when a new form is opened, its appears behind the current open forms.

Perhaps the first form opened has it's PopUp property set to Yes

[BertBruggeman]

yes both modal as popup are set to true for all forms.
And on some computers they show most of the times.. but unfortunately on some computer almost never.

[Minty]

A Modal or Pop up form will remain on top of all others, unless something on that form opens another modal or popup form.
A modal form retains the focus until it is closed or another modal form is opened from it.

So the order they appear should be determined by the properties they are opened with.

[BertBruggeman]

A Modal or Pop up form will remain on top of all others, unless something on that form opens another modal or popup form.
A modal form retains the focus until it is closed or another modal form is opened from it.

So the order they appear should be determined by the properties they are opened with.

But both modal/popup are set to true for all forms, and normally they just show in front.
In past it worked almost most of the times, but now last weeks we got many people complaining.
So i thought maybe someone knows a truc to bring it to front, when normal open fails.
Or can tell me why it happens.

[Bob Fitz]

But both modal/popup are set to true for all forms, and normally they just show in front.

Are they opened by using a button on the last form that was opened?
If not, describe what the user does to open the form.

[BertBruggeman]

Yes indeed, except for the first form start through macro, all forms are opened by a button on the top/active form.

[Bob Fitz]

Yes indeed, except for the first form start through macro, all forms are opened by a button on the top/active form.

Then, as Minty has already stated, they should open on top. If they don't open on top I would question if the Modal and PopUp properties are really set to Yes.
Perhaps you could post a copy of the db for us to examine.

[BertBruggeman]

Thanx all.. after optimizing some queries someone here made, everything works to seem better,, so i think this topic can be closed..

and sorry i didn't read guideline good enough, asked same question on microsoft forum side, as i excepted to get slow response there, i googled acces forums, and got here. next time i will ask here.