delete with code

  • Thread starter Thread starter smk23
  • Start date Start date
S

smk23

I would like to use a command button to delete a record. What is the syntax
to delete the current record?

Thanks,
Sam
 
To delete the current record, you could do this:

strSQL = DELETE * FROM SomeTable WHERE keyfield = " & Me.txtKeyField & ";"
Currentdb.Execute(strSQL), dbFailOnError
Me.Requery

SomeTable would be the table or query that is the same as the record source
of your form. keyfield would be the primary key field of the table and
Me.txtKeyField would be the control on the form that is bound to keyfield.

If you don't have the keyfield bound to a control on your form, you could
use the field in the form's recordset:

strSQL = DELETE * FROM SomeTable WHERE keyfield = " &
Me.Recordset![keyfield] & ";"

The only difference to delete multiple rows would be to write the WHERE
clause to include the records you want deleted.

Note the Me.Requery is important in that you are deleting from the
underlying table and the Requery will also remove them from the form's
recordset.
 
Back
Top