Hi
I have a simple Access form with a button that creates a new record.
There is however no btton to save the entries made to the table.
What VBA code would I use to commit the data to the table
and what measures would I need to stop the data from automatically being saved to the table
without clicking the buton
I used the following code which seemed to work but am not sure exactly what it does
On Error GoTo ErrN
DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70
Exit Sub
ErrN:
MsgBox Err.Description
MsgBox ("There was a problem saving this record!")
Start Free Trial