I have a delete button on my microsoft access form.

In the OnClick for the button I have VBA code and in that VBA code I can identify the current record using Me.CurrentRecord.

What is the SQL statement do delete that specific record?

DELETE FROM tablename where ???

Thanks

CodePudding user response：

Let the form delete the record:

' DoCmd.SetWarnings False
DoCmd.RunCommand acCmdSelectRecord
DoCmd.RunCommand acCmdDelete
' DoCmd.SetWarnings True