Check for duplicate field before saving
Posted on 2015-01-26
I have a form for creating new student accounts. We have to create a username for the student and while our preference is first initial + last name, this cannot always work because of people with the similar names (e.g., Mary Smith and Michelle Smith). The field is a text field with the index (no duplicates) property so we find out once the record is complete if we've duplicated someone.
Is there a way to check this field before all the data is entered so we can create a new username right away? Is there some code that I can add to the field in the OnChange event that will see if this username is already present in the table and pop up with a message?