How to work the Save Button to save to database

To work the Save Button to save to database

Step 1:

To save data directly to database from a button, add a Command button to the form:

Step 2:

Set the Caption properties:

Caption=Save

Step 3:

Double click on the button and write down the programming codes:

Private Sub Command6_Click()

Adodc1.Recordset.Update

End Sub

This will save and update the data directly to the database file after clicking on the 'Save' button.