Bring Form To Front

[Alireza355]

I have an access database, with the default switchboard opening and maximizing on startup.

I have put an ON-LOAD event, that opens a pop-up, modal form called frmLogin to ask for username.

When the application starts, the switchboard opens, maximises, and the frmLogin form pops up.

But sometimes, I don't know why, the pop-up form is not on the top.

I tried different methods:

frmLogin.setfocus

or

on-timer of switchboard (every 2 seconds) I tried using this:

if [forms]![frmLogin].isloaded = true then

frmLogin.setfocus

end if

but it doesn't seem to be working.

Is there another more POWERFUL!!!!!! way of bringing the frmLogin to front?

[DonRayner]

Popup forms will always be on top of other forms unless the other form is also a popup.

When a forms modal property is set to true, you can't leave the focus of that form untill it's closed. That means you can't set focus to it because it already has the focus.

At times something is delaying the opening of your switchboard form and it is being rendered after your popup form. since they both have their popup properties set to true, the last one opened will be on top. Now since your popup form is also a modal it still has the focus even though you cant see it. Therefor trying to setfocus to it through vba will have no effect.

Some possible solutions would be.

1. If there is a lot of code in the On Open event for your switchboard, you could try moving the call for your popup to the end of the "On Open" event, just before the sub exits.

2. Change the popup's modal property to no so that the setfocus would work.

3. Change the switchboards popup property to no so that it wouldn't sit on top of your popup.

4. You could move the call for your popup from the On Load event to the On Timer event.

Don

[Alireza355]

Thanx a lot Don.

Will give it a try.

Best Regards,
Alireza355

[DonRayner]

You're quite welcome

[missinglinq]

Don's suggestion # 3 really makes the mosts sense of the four! Why would you have a Switchboard form set to Popup? Most developers, if they're going to leave a Switchboard form loaded, want it under subsequently opening forms, not on top, which it will be unless all others forms have Popup set to True as well.

Of course, if I were doing it, I'd have the login form load first when the database opened, then load the Switchboard from that form.

Linq ;0)>

[Bruce Robbins]

I also had this problem. It seems that the On Load event opens the pop up form before it has completed loading its own form. I solved the problem by putting a counter into the On Load event to give the form more time to load itself before opening the pop up form. The event code looks like this:

Private Sub Form_Load()

Dim i As Integer

Do Until i = 10000
i = i + 1
Loop

DoCmd.OpenForm "dlgSelectCamper"

End Sub