How to set the focus? (1 Viewer)

[cheberdy]

I have a menu with which I can navigate between forms. When I open one of the forms I would like to have it in the foreground and not in the background.
How to do this?

 

[theDBguy]

You could try using popup forms or open it in dialog mode.

 

[Pat Hartman]

If you are having trouble with this, you are already using popups. Try NOT using popups. What I do is to hide the calling form because having multiple forms open at one time just causes confusion and if you don't use dialog mode, the user can update data on multiple forms and forget what record he is really working with - dangerous.

I pass in the name of the current form:

    DoCmd.OpenForm "form name", , , "where condition", , acDialog, Me.Name
    Me.Visible = False

Then, the called form uses the OpenArgs to reopen the calling form.

IF Me.OpenArgs & "" = "" Then
    'open the switchboard
Else
    DoCmd.OpenForm Me.Name
End IF