Set focus to another form

[aytee111]

I have tried everything posted but nothing seems to be working. This seems such a simple task.

Situation: open database, show main form, open second form, bring second form to the fore.

This is the sequence of events according to MS.

Open Load Resize Activate Current

In On Current of the main form I have:
DoCmd.OpenForm formx (variable)
Forms(formx).SetFocus

I tried putting the actual form name instead of the variable but that didn't work either. Any help will be greatly appreciated.

[ItsMe]

if you want to set focus on a form you can use its fully qualified name to access the SetFocus method.

Forms!FormName.SetFocus

However, the following line should open the form and set focus on that form
DoCmd.OpenForm "FormName"

[aytee111]

Thanks for responding.

I tried using the fully-qualified name, still didn't work.

I already have the DoCmd.Openform statement, that does not set the focus on the form either.

[ItsMe]

...I already have the DoCmd.Openform statement, that does not set the focus on the form either....

Those are the two methods I use. However, forms do not always have the capability to receive focus. Perhaps there is a control in your form that is capable of receiving focus. However, you should get a runtime exception if there is not a capability to setfocus on the form or a control. Make sure you are not using a modal property = True on an open form.

DoCmd.OpenForm "FormName"
Forms!FormName!ControlName.SetFocus

[aytee111]

I have replicated my problem here, maybe you can see what I am doing wrong.

[azhar2006]

You have to put code in the event click on the button.

Private Sub Command1_Click()
    DoCmd.OpenForm "Form2"
    Forms!Form2!text1.SetFocus
End Sub

[aytee111]

The form doesn't have a button to click on - that is what I am trying to accomplish, no button, automated opening of form 2.

[azhar2006]

Mark event in Timer

[aytee111]

Sorry, don't get that. This must only happen when the database is first opened, I don't want to set a timer event that will continually be running, if that is what you are suggesting?

[azhar2006]

See this example

[ItsMe]

Sorry, don't get that. This must only happen when the database is first opened, I don't want to set a timer event that will continually be running, if that is what you are suggesting?

If you want a form to open when the database is opened you can select the name of the form within the database's options. Click on the File tab within the Ribbon and click 'Options'. The 'Access Options' window will open. Under 'Current Database', select the correct form name for the 'Display Form:' option.

[aytee111]

Thanks for your examples. The two choices you gave me are to (1) have a timer running continuously or (2) make the second form a popup. Neither of those fit in with what I am trying to do. I cannot believe that this is not possible, to give another form the focus, a plain and simple form, without going through these hoops. I told the user that I could open the database to the form they use the most, saving them going through the main screen every time, without closing the main form and without forcing them to stay there (which is what the popup does).

Like I say, a simple enough request yet impossible to accomplish!

[ItsMe]

It is not clear to me what you are trying to accomplish. If you need to open a second form when the application opens, I would place vba in the Default Form's On Load event.
DoCmd.OpenForm "FormName"

[aytee111]

Sorry for not explaining myself properly. The database that I attached earlier is how mine is set up: open form1, form2 opens automatically and brought to the front - that last part is what is not happening, form1 is still the one in front.

[ItsMe]

OK, I see what you want and why it is happening the way it is. I suppose using the timer of Form1 is an option. I would set From2 as the Default form to open and place the following in the On Load of Form2.

DoCmd.OpenForm "Form1"