Save Record
acCmdSaveRecord
This simple piece of code saves the current record. It is designed to run behind a button called cmdSave.
'***************** Code Start *******************
' Code by Terry Wickenden
Private Sub cmdSave_Click()
On Error GoTo ErrHandler
DoCmd.RunCommand acCmdSaveRecord
Exit Sub
ErrHandler:
MsgBox Err.Number & vbCRLF & Err.Description
End Sub
'****************** Code End ********************