Open and closing form problem 2

[jpl458]

I have a form that has a close button and a print button, that were made with the button wizard.. i can only get to this form from another form, say form A. If I close "B" then i return to form A. But after I print the form "B" and hit the close button I go to the ACCESS window with the lists of queries, etc. After I print, just want to hit CLOSE and go back to Form A

Thanks in advance

jpl

 

[randy700]

Private Sub cmdClose_Click()
    DoCmd.OpenForm "formA"
    DoCmd.Close acForm, "formB"
End Sub

Randy

 

[PHV]

You may try this:

Private Sub cmdClose_Click()
' your actual code here
Forms![form A].SetFocus
End Sub

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

 

[jpl458]

Thanks guys

jpl