View Single Post
  #1  
Old April 29th, 2008, 05:07 PM posted to microsoft.public.access.forms
Dean Hastas
external usenet poster
 
Posts: 1
Default 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