Wrong form has focus - how to set on the proper form? (1 Viewer)

[Russ05]

Hi everyone, I have a simple database which is storing annual leave applications and their approval status. I have a Employee form (frmEmployeeDetails) showing employee details. I have a button on that form which opens another form and allows the user to enter the last working day (date), return to work day (date) from calendar. A function then calculates annual leave days and public holidays based on those dates. A recordset is created for each week of leave. I have a button on the form which creates the recordset(s) to load into a subform (frmALSched) on the form (Form1). This is where the problem occurs.
Using DAO recordset to create a new record and enter each record into the subform, which was working great, until now. For some reason the form on which the subform exists is not the active form even after I set it as such. When the code reaches the following lines

With Forms!Form1!frmALSched.Form
DoCmd.GoToRecord , , acNewRec

The frmEmployeeDetails form actually goes to a new Record. Obviously, it appears to have the focus.

So I tried the folllowing lines of code:

Forms!Form1.SetFocus 'Sets focus on the form containing the subform
Me!frmALSched.SetFocus 'Sets focus on the subform control

Set frmCurrentForm = Screen.ActiveForm
Debug.Print "Current form is " & frmCurrentForm.Name

I receive this "Current form is frmEmployeeDetails" in the immediate window.

I cannot understand or workout why the Form1 isn't the form in focus as I believe I have set focus on Form1.ALSched.

Any advice will be greatly appreciated. I have come to the breaking point stage after trying to crack this one for the past few days.

 

[Minty]

Try setting the focus to a control on the subform.
The subform control is exactly that a control on the main form, so at that point the current form is the main form.
A subform FORM can't really be the activeform as it's a control on the main form.

I hope that helps?

 

[Pat Hartman]

The best practice when you want to have two forms visible at once is to have the first form open the second as model. That stops the code in the calling form and keeps the focus in the popup form until it is closed.

 

[arnelgp]

Forms!Form1.SetFocus
Forms!Form1!frmALSched.Form.SetFocus
Forms!Form1!frmALSched.Form!fieldInTheSubForm.SetFocus

 

[Russ05]

Many thanks to all respondents, very much appreciated. Despite having thought I had tried everything to and constructed my code, I have learned a valuable lesson. I hadn't opened the "Form1" as modal. Once done it worked great. Can't thank you enough, now I can move onto my next challenge.
Hope I can repay in some way to others in the future.

 

[Pat Hartman]

Glad to help

 

[missinglinq]

And FYI...you can only SetFocus to a Form if it has no Controls which may have Focus.