Add Code to Submit Changes to the Database

Search for the words "Tutorial - Submit Changes to the Database." Copy the following script and paste it under the comment.

SUB Submit_OnClick  ' Submit Changes button clicked.
  ADC.SubmitChanges ' Send changes to the DBMS.
  ADC.Refresh	     ' Refresh the recordset.
End Sub

When ADC.SubmitChanges executes, Remote Data Service packages all the update information and sends it to the server via HTTP. The update is all-or-nothing; if a part of the update isn't successful, none of the changes are made, and a status message is returned.