Help with GotFocus

[Razor1]

I have a form that is open and when the input on that form is completed I open another form with the timer value set to close in 5 sec. I then want to set the original the focus to a field. The focus is not set to any field when I close thethe original.

Here is the process I am using:
'Open original form frm_HC_Assembly
'Write Record
'Clear Fields on original form
'Open Complete Notice Form Runs for 5 sec
DoCmd.OpenForm "frm_CompletedNotice", acNormal, , , acFormReadOnly
'close Complete Notice Form
'Set focus to Original Form
Forms!frm_HC_Assembly.SetFocus
Forms!frm_HC_Assembly!HCSerialNo.SetFocus



Razor1

 

[vbajock]

Issuing docmd.openform "frm_HC_Assembly" will set the focus to the form even if the form is already open, then you would issue your

Forms!frm_HC_Assembly!HCSerialNo.SetFocus

to move to the field.

 

[Razor1]

That worked. Thanks

Razor1