I have a indexed field that must be unique for every record. I'd like to immediately check for uniqueness when the field has lost it's focus as well as have a custom error message to notify the user. Currently the record will only give the default Access error when the record is saved and the indexed field happens to be a duplicate. Thanks for the help.