Check for duplicate records after inputing a value in the "last field".
Posted on 2004-09-02
I'm using MS Access 2003 VB 6.3.
I have a "Guest" from that has basic guest information in it like
all field are text fields that are bound to the corresponding attribute in the Guest table.
After the user leaves the "GuestZip" field, I need to check the "GuestFirst", "GuestLast", " Guest Zip", and "Guest Phone" values in the form against values in the table and if there is a record with the same value in those four fields - I need to have an selection box that comes back and tells the user "this guest already exists" and then gives the user the options of "Enter Guest Stay" or "Enter Guest Feedback" - and once the appropraite selection is pushed - opens the form in add record mode.
I'm a bit of a "newby" so a detailed response would be greatly appreciated.