Open a another form and Close this one

[Bob Vance]

I am trying to open a form "frmRemarks"
and close the form that my control button is on
Private Sub cmdDCDShortcut_Click()
DoCmd.OpenForm "frmRemarks"
DoCmd.Close acForm, Me.Name

End Sub

 

[Bob Vance]

oops sorry got it,
Private Sub cmdDCDShortcut_Click()

DoCmd.Close acForm, Me.Name
DoCmd.OpenForm "frmRemarks"
End Sub

 

[Ken Snell \(MVP\)]

It's better to reverse the order of the steps:

Private Sub cmdDCDShortcut_Click()
DoCmd.OpenForm "frmRemarks"
DoCmd.Close acForm, Me.Name
End Sub

--

Ken Snell
<MS ACCESS MVP>

oops sorry got it,
Private Sub cmdDCDShortcut_Click()

DoCmd.Close acForm, Me.Name
DoCmd.OpenForm "frmRemarks"
End Sub