close active form and open another form w/button

[cwash]

How do I make a button close the active form and open another form? Basically, I have a form with a button, that "on click" will take me to the "main form." I want that same button to also close the active form.

So, how do I get a button to have two actions, close the active form and then open another form?

I am new at Access, so if possible, please explain on the assumption you are speaking to a newbee.

TIA

 

[PHV]

What is the actual VBA code of your button's Click event procedure ?

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

 

[cwash]

The 'opnMain' is the button on the active form- the "main" form opens, but the active form remains open.

Private Sub opnMain_Click()
On Error GoTo Err_opnMain_Click

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "frmMain"
DoCmd.OpenForm stDocName, , , stLinkCriteria

Exit_opnMain_Click:
Exit Sub

Err_opnMain_Click:
MsgBox Err.Description
Resume Exit_opnMain_Click

End Sub

 

[PHV]

you may try this:

Private Sub opnMain_Click()
On Error GoTo Err_opnMain_Click

    Dim stDocName As String
    Dim stLinkCriteria As String

    stDocName = "frmMain"
    DoCmd.OpenForm stDocName, , , stLinkCriteria
    [!]DoCmd.Close acForm, Me.Name[/!]

Exit_opnMain_Click:
    Exit Sub

Err_opnMain_Click:
    MsgBox Err.Description
    Resume Exit_opnMain_Click
    
End Sub

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

 

[cwash]

PH-

Does my form name replace the "Me" or the "Name"? (or do I leave the Me.Name as they are?

I'm referring to the line below.


DoCmd.Close acForm, Me.Name

TIA

 

[PHV]

What happens if you leave the Me.Name as they are?

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

 

[cwash]

I was getting an "argument" an "object" msg when I orginally left it as is, so I replaced the Me and Name (independantly) with my form name but was still getting the msgs.

I then reverted back to your Me.Name and now it works!! I don't know what I did, but now it works!

PH...Thank you very much!!