Looking at the cross post, you're creating problems, I think, by trying to add a custom error message to your 'add record' button code! Once the custom error message is handled in the Form_Error event, as you've done, it will always display this message for Error 3022, regardless of what event triggers the error! To repeat...your code only needs to be in the Form_Error event.
Linq ;0)>
The problem with making anything foolproof...is that fools are so darn ingenious!
All posts/responses based on Access 2003/2007