Prevent duplicate entries

  • Thread starter Thread starter aveightr
  • Start date Start date
A

aveightr

I am new to Access and have finally constructed a
database that will work for me. I am trying to come up
with a method for preventing me from adding duplicate
information into a field in my Form. I have
selected "Yes, No Duplicates" in the Indexed box. But
then I don't find out the field is duplicated until I
have finished filling out the entire form and am ready to
go to the next form. Is there a way I can be notified as
soon as I enter duplicate information into a field?
Thanks!
 
You didn't mention what type of control you are trying to enter information
into. One possibility would be to add a procedure to the AfterUpdate event
of that control that checks the underlying data for duplication, provides a
message if duplicated, and erases the entry.

Does this mean the user has to "guess" at valid values? Is there a way you
could display a list of the already used values (say, in a list or combo
box)?
 
Back
Top