**how can i delete a record on a database?
im using this codes:
Private Sub cmdDelete_Click() Dim con As ADODB.Connection Set con = New ADODB.Connection Dim rsDelete As ADODB.Recordset Set rsDelete = New ADODB.Recordset MsgBox "Are you sure you want to delete?", vbYesNo, "Santo Niño Census Info System" ' i dont know next.. End Sub
please help..im new to vb..thanks