vbYESNO

[CLOS]

I need some expert Help with this one!

I have a command button that will display a message to the
user prompting them with either a 'YES' or 'NO' question to
confirm a record delete. Now, if a user's response is 'YES',
I want to delete the record. If a user's response is 'No',
I want to cancel the action. Could somebody code this for
me? Thanks!

 

[dawnd3]

Hopefully this will help a bit. I have left some parts out having to do with the response of the vbquestion because I don't know them on the top of my head, but I am sure someone else here does But I think this is almost what you want.

If MsgBox("Your question here in quotes", vbYesNo + vbQuestion, "Name of message box here&quot = vbYes Then
DoCmd.DoCmd.DoMenuItem acFormBar, acEditMenu, acDelete
Response = ?
Else
Response = code to cancel
Me.[FieldName].SetFocus
End If

http://www.calliopeconsulting.net