To delete a record in a database, you can add a control such as a Delete button to the page. The button calls the recordset's delete method to delete the current record.
You might not always be able to delete records. You need the correct settings for your recordset, adequate permissions in the database, and sufficient information to uniquely identify records. For details, see Determining When Query Results Can Be Updated.
To delete records in script
Sub btnDelete_onclick
rsEmployeeList.deleteRecord
End sub
By default, the script illustrated above causes the page to display the record immediately following the one just deleted. If you prefer that the page display a different record, you can insert a navigation method in front of the return statement. The following example shows how you would move to the preceding record:
rsEmployeeList.deleteRecord;
rsEmployeeList.movePrevious;
For more information about writing event handlers for design-time controls, see Writing Scripts for Script Objects.