Try this out, you can either put it in the Form Close area of your form or you can assign it go a cammand button. If you need more detail just ask
Code:
Private Sub Form_Close(Cancel As Integer)
'Message box warning of Comment needed
strMsg = "WARNING!!! Comment is required when creating a new record. Click ok to open the Remarks"
If MsgBox(strMsg, vbOKOnly + vbCritical, "Remarks Needed") = vbOK Then
Dim stDocName As String
Dim stLinkCriteria As String
'Opens a different form with matching criteria
stDocName = "frmRemarks"
'The first brakets put the field name of your ID key that will match up to the frmRemarsk table. The second braket name the field of the ID key thats in your frmRemarsk table.
stLinkCriteria = "[CurrentFormID]=" & Me![frmRemarks_IDfield]
DoCmd.OpenForm stDocName, , , stLinkCriteria
'Closes out the original form you work on
DoCmd.Close acForm, "frmProjects"
End If
End Sub
Regards Viper