DataErr = 2169

[Glenn Brown]

I've got a problem with some of my forms closing gracefully….when a user
closes a form that does include valid data of doesn’t satisfy all rules, I
want the code below to remove any data and close the form with out questions.
The code below generally works, but not all the time.

Does anyone have any suggestions?

Thanks again Glenn

If DataErr = 2169 Then
Me.Undo
Response = acDataErrContinue ' Don't display the default message
End If

 

[TonyT]

Under what circumstances does that code not work? errors other than 2169? If
so which ones and why?

TonyT..