I have a database that holds information about prospective students (name, address, phone number, email etc etc).
There is a form set up for entry of new records. What I want to be able to do is after someone enters the first name and last name, access searches the table to see if there are any matching records and displays the details (address, phone, email) in a message box. This is a way of checking for duplicate records before entering data. (For example, you might be entering data for a John Smith in Sydney and there might already be a John Smith in the database but he might live in Melbourne. Or Sally Jones from Sydney might have emailed to say she wanted to be put on the database and then phoned as well. So when you go to enter her details a second time, you can see that she is already in the database.)
I was thinking to put code behind the AfterUpdate event of the last name field and I know it would have something to do with opening and querying recordsets but i'm just not sure how to do it.
Hope that makes sense.