Add Or Delete Records In Business. Click the Delete button on the ribbon. Create a separate button control in this form and in its set up select it to delete current record.
When the user deletes a record. Sub AddRecord add a new record to the local disconnected recordset rsContactsAddNew commit the new empty record to the local disconnected recordset rsContactsUpdate clear the current controls on the form so the user can fill in values for the new record Call. Create a separate button control in this form and in its set up select it to add new record.
Label this your delete button.
You need to write multiple delete statements. Zip codes payment terms accounting periods etc. In reality deletion can take countless forms. Delete from dept where DEPTNO IN Select aDEPTNO from emp a dept b where aDEPTNObDEPTNO and aDEPTNO10 delete from emp where DEPTNO IN Select aDEPTNO from emp a dept b where aDEPTNObDEPTNO.