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]

This is a duplicate post!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!