In vb5, I have code that works fine to delete a record if the name is "Brown"
sName = Brown
Set dbtemp = OpenDatabase(dbname)
dbtemp.Execute "DELETE * FROM List1 WHERE Name = " & "'" & sName & "'"
Do I need a trap in case there are is no Brown in the Name field.