Form Validation

[whitelexi]

I have a form with which my colleagues and i enter data into a table. I would like to make sure that the same data is not entered twice by 2 or more different people, so i want to attach a validation code that would check that the reference number has not been entered into that table in the past, before accepting the data.

Can anyone pls refresh my memory on what code i need to achieve this?

 

[DCrake]

You can use a DLookup command to check for the existance of the code in the after update property of the control. If found tell user already in system.

David

 

[whitelexi]

You can use a DLookup command to check for the existance of the code in the after update property of the control. If found tell user already in system.

David

How would u phrase the code? If the table is called tblAnalysts and u want to make sure duplicate data is not entered into the column called Reference? The syntax for the code line is where i'm having problems.

Thanks