Duplicates

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

While I’m adding/editing a record in a form, I don't like to allow duplicate
entries in a field and the field must not be empty. Could I work with the
validation rule and how can I check for existing values?
 
While I’m adding/editing a record in a form, I don't like to allow duplicate
entries in a field and the field must not be empty. Could I work with the
validation rule and how can I check for existing values?
Click to expand...

The simplest way to prevent empty or duplicate fields is to use table design
view; select the field, view its properties, and set Required to Yes, and
Indexed to Indexes (Unique Values).

John W. Vinson [MVP]
 
Back
Top