Prevent Duplicate Data in Form on a Fly...

[darno]

Hi,

I have searched through the whole posts but could not find my query. I have a question related to prevent duplicate data entry in a form field.

I have a Form with 5 fileds on it: SNO, NAME, ROLL NO, CLASS, SECTION.

in the table design i have set the option of NO DUPLICATES on SNO(Autonumber) ROLL NO (text).

I wish to stop a user entering duplicate data in ROLL NO field before he reaches at the last field. What i meant is as soon as a user enters data in ROLL No field, it should check in table if the same data is already there. If the same data is found then it should give a message to prompt user of duplicate data, else it should continue to next field.

I have searched the whole forum but in vain. I am positive that there must be some one who holds the key to this solution.

Regards,

Darno

 

[RuralGuy]

There is a couple of issues. It would be better to check for duplicates with a DLookup() in the BeforeUpdate event of the control that displays the [ROLL NO] and set Cancel = True if it is a duplicate. You are also using reserved words for field names which *will* cause you grief.
List of reserved words in Access 2002 and Access 2003
List of Microsoft Jet 4.0 reserved words
Special characters that you must avoid when you work with Access databases