I have a users form based on a users table where the primary key is the username. I'd like to add code to give my own error message when a duplicate username is entered instead of Access's default error message.
Is it preferable to put this code in the BeforeUpdate event of the control or the form? Or somewhere else?
Can anyone provide me with sample code?