Checking if data already exist in a Table

[Phillsoft]

Hi Guys

I have a form with a number of fields that includes Learner Name, Surname, ID Type, IDNo just to mention a few. IDNo is a primary key. I would want a simple VBA code that can validate if the IDNo already exist in the table the moment it (IDNo) loses its focus when a user is entering data. Currently the form will only pop up a message when you have finished populating it since it is a primary key and its not user friendly. Can someone help


Thanks

[orange]

To see if IDNo already exists in MyTable you could use a
If DCount ( expression) > 0

see http://www.techonthenet.com/access/f...ain/dcount.php

[rpeare]

if the record already exists are your data entry people supposed to update the existing record?

If so why not perform a search first (first field is an unbound text box) and if the person exists populate your form, if they don't then take them to a new record and populate the ID field for them?