"You are about to delete 1 records....."

[Jeff Klein]

I am using the following code to cancel and close a form that is sourcesd to
a table.

DoCmd.DoMenuItem acFormBar, acEditMenu, acUndo, , acMenuVer70
DoCmd.Close

When this code is executed it sends the following message:

"You are about to delete 1 records....."

Is there a way to use this code and not have the notice appear?

 

[Allen Browne]

Try:
If Me.Dirty Then Me.Undo
DoCmd.Close acForm, Me.Name

It should not generate a "delete" warning.

 

[Jeff Klein]

Answered it myself
DoCmd.SetWarnings False

 

[Allen Browne]

Hmm. That sure supressses the warning, but it does not deal with the cause
(i.e. why you were getting it in the first place.)