Duplicate entries

  • Thread starter Thread starter nikko50
  • Start date Start date
N

nikko50

Hi there. How do I have an Access form disallow duplicate entries. Her
is what I have. I have an input prompt where the user inputs the stor
number. Then the store number will be entered into the form. How can
have that input prompt compare the store number entered by the user an
check to see if an entry for that store has already beenbeen enteredi
the table. Any help would be awesome!!
Sharon:))
 
I would like the have the "INPUT STORE" prompt compare the store entere
to see if there is any duplicate values in the store table. If ye
prompt " Enter new store number". How do I go about doing this.
Sharon:)
 
Use distinct in the text box properties:

properties - row Source- select DISTINCT [****] etc
 
Back
Top