Get rid of the "You're about to delete ... " msg.
This sounds so silly. I've been trying for an hour to delete a record found in a tabletype recordset without displaying the Access standard message "You are about to delete x records..." you know.
I already have my own msgbox() function that asks for confirming the deletion.
I've tried DoCmd.SetWarnings False and later back to True.
I've tried SetOption with "Confirm Record Changes" to False then back to True. I also tried a few other ones to no avail.
I am sure I did that in the past and had no problems at all finding the information. Here's a portion of the code:
If MsgBox("Delete record?") = vbYes Then
Dim dbs As DAO.Database
Dim rst As DAO.Recordset
Set dbs = CurrentDb()
Set rst = dbs.OpenRecordset("tblzzz", dbOpenTable)
.Index = "PrimaryKey"
.Seek "=", Me!EtudID, Me!FinDetailAn
If Not .NoMatch Then
DisplayExclamation "Not found"
This code is in the OnDelete event of the form. As I think of it could it belong to another event like BeforeDelConfirm? Hum I'm on my way to try this.
If anybody can help I would appreciate.