How do I us SETFOCUS to a text box upon return to form

[djj55]

In Access XP SP3

The form has a button that opens another form. When the second form is closed I want the focus to be a particular text box. I assume it is done with me.txtbox.setfocus but where do I put the code?
form current
form gotfocus
form ???

Thanks

djj
The Lord is My Shepard (Psalm 23) - I need someone to lead me!

 

[PHV]

a button that opens another form
What is the VBA code doing that ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[djj55]

There are two, the first one I can add the code to the button click code, the second one is where the problem occurs. If I add the code to the second click code will if fire at a bad time where me. is not defined or the wrong form?

    DoCmd.OpenForm stDocName, , , , , acDialog
    DoCmd.OpenForm stDocName

djj
The Lord is My Shepard (Psalm 23) - I need someone to lead me!

 

[PHV]

Why not using acDialog too in the second click code ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[ZiggyS1]

try in the close event of the second form...

Forms!yourFormname!yourControlname.SetFocus