Check if value already exists

[ya5irha55an]

Hi, I have the following problem which I hope someone can help me with:

I have a form which is used to enter data into a table. One of the fields is 'Code'. I want the form to check when data is enetered into this field is it already exists, ie if the code is already present in the 'code' field in the table, and if it is it should give a warning message, if not then continue as normal.

Any help would be greatly appreciated, thanks in advance!

 

[Avikash2006]

No Data Repeat

Hi

U can try the following.

Open your table in Design View.
Select your field called 'code'
In the INDEXED properties to 'yes no Duplicates'

Hope this is your answer.

 

[ya5irha55an]

Not quite- I dont necessarily want their to be no duplicates, but I want there to be a warning if a duplicate is being entered- most of the time this will be an error if someone is trying to add a code which is already there, but not all the time. Thanks anyway tho.