delete record

[viral1982]

I have following fields

First Name
Middle Name
Last Name

And three buttons

Add,Delete and update

I want to delete entered records

[vb5prgrmr]

If you want to delete all records then...(guessin g you have some sort of database access going on...ADO)

strSQL = "DELETE FROM tablename"
Cm.Execute strSQL

or if you are wanting to delete just a single record or records based upon some criteria then...

strSQL = "DELETE FROM tablename WHERE [First Name] = '" & SomeVariableValue & "' AND '" & [Middle Name] = '" & SomeOtherVariableValue & "'"
Cm.Execute strSQL

Good Luck