When to catch Access Dataerr 8517 “Do you want to suppress further error messages for why you can't

[justinr12345]

I am programming my Audit table to handle events when a user deletes multiple records which have referential integrity errors preventing it from being deleted (Access DataErr 3200). If a user deletes multiple records with errors, access will ask to suppress further error messages, if YES is selected, the error event wont run for the bad records, thus causing a build-up of bad Audit records. Where can I catch this error and ideally program it to 'No' so it displays each error. I cant use DoCmd.SetWarnings as that auto seelcts 'Yes' and I am trying to auto select 'No'. Thanks

[justinr12345]

Bump..............

[isladogs]

Not sure I follow but perhaps use this in your error handler????

if err=3200 Then Resume Next

[justinr12345]

Not sure I follow but perhaps use this in your error handler????

if err=3200 Then Resume Next

I am attempting to handle error 8517 "Do you want to suppress further error messages for why you cant delete", except the error is never passed to Form_Error. You can replicate by deleting two records with referential integrity errors. The BeforeUpdate event hits, then the Error event with DataErr=3200. Once the Error event passes we get the popup for error 3200, then the popup suppress message for 8517. I dont understand how two errors (3200 and 8517) are happening simultaneously? I can't leave DoCmd.SetWarnings False either as it auto selects 'Yes' to suppress further error messages and I am attempting to program it always to choose 'No;.

[isladogs]

As you have the problem, please post a sample for us to work on.