Delete Record

[MFS]

Hello all,
I am trying to delete a record in a table by having a command button on my form.


When the Delete button is pressed I would like it to ask me "Enter part number" then show those fields related to that part number on my form or inform part number does not exist. If data does exist I would like to be able to review data and confirm delete.
I've tried but have been unsuccessful.
Hopefully someone can help me.
Mike

[MFS]

Found this VB.
Private Sub DeleteButton_Click()
If MsgBox(Prompt:="My question", Buttons:=vbYesNo) = vbYes Then
CurrentDb.Execute "DELETE FROM tablename WHERE ID=" & Me.ID
Else
MsgBox "Delete canceled"
End If
End Sub