Close a form from another form

[pls001]

I created a form (frmUSERS AND PASS) to access a menu located in another form(frmREPORTS MENU). frmUSERS AND PASS allow users to open the report menu and execute whatever they want depending on a security level. When I get into the frmREPORTS MENU I'm not able to close the frm USERS AND PASS. I don't understand why. I tried several approaches with no success. Please help. thank you all in advance

[rzw0wr]

Are you saying that Access refuses to let you close them OR are you looking for a way to close them from an other form.
Your title says one thing however your post says something different.

Please explain what it is you want.

Dale

[pls001]

I'm looking for a way to close the frmUSERS AND PASS form, after opening the from frmREPORTS MENU. I used DoCmd.close "frmUSERS AND PASS" ON OPEN event OF THE frmREPOTS MENU.
I tried using also the ON LOAD event and other things but I get the same results ACTION FAILED.

[rzw0wr]

I used DoCmd.close "frmUSERS AND PASS" ON OPEN event OF THE frmREPOTS MENU

Docmd.Close "frmUsers", acSavNo
Docmd.Close "frmPass",acsaveNo

Dale

[pls001]

Yes Dale,
I used docmd.close "frmUSERS AND PASS", acSavNo.

Docmd.Close "frmUsers", acSavNo
Docmd.Close "frmPass",acsaveNo

Dale

[Bob Fitz]

I think your code is missing a comma. Try:
DoCmd.close , "frmUSERS AND PASS"

[Bob Fitz]

I think your code is missing a comma. Try:
DoCmd.close , "frmUSERS AND PASS"

[Dal Jeanis]

By the way, if you will always close the first form after you open the second form, you can do it in the first form.

Private Sub cmdNext_Click()
On Error GoTo Err_cmdNext_Click
    Dim stDocName As String
    Dim stLinkCriteria As String

    stDocName = "frmNextFormName"
    DoCmd.OpenForm stDocName, , , stLinkCriteria
    DoCmd.Close acForm, Me.Name
    
Exit_cmdNext_Click:
    Exit Sub

Err_cmdNext_Click:
    MsgBox Err.Description
    Resume Exit_cmdNext_Click
    
End Sub