save record button easier way?
Using Access 2003 Whats the easiest way to save a record after edit and
after insert behind a save commnad button. For example query1.posts ect
ect. Below is what the command button generates
but must be a cleaner way?
Thaks for any help
Private Sub Command59_Click()
On Error GoTo Err_Command59_Click
DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70
Exit_Command59_Click:
Exit Sub
Err_Command59_Click:
MsgBox Err.DESCRIPTION
Resume Exit_Command59_Click
End Sub
|