When a DoCmd Action is called from VBA code but cancelled by user a runtime error occurs. This is error 2501. I usually trap this VBA.Err and Resume to the exit line label in my error handling structure.