I have a table with the primary key set to EmployeeID.
Users will be inputting information via a form. I would like a message to pop up after the user enters the EmployeeID on the form to confirm that it is correct before they proceed. I also need to have a message pop up if the EmployeeID already exists (they wouldn’t be able to save the record anyways) and to verify their EmployeeID or contact administration for support.
I’m thinking that I would do this in VB code and set it in the lost focus event of the textbox. I’m not sure how to code it.
Any help would greatly be appreciated.
Thanks.
Users will be inputting information via a form. I would like a message to pop up after the user enters the EmployeeID on the form to confirm that it is correct before they proceed. I also need to have a message pop up if the EmployeeID already exists (they wouldn’t be able to save the record anyways) and to verify their EmployeeID or contact administration for support.
I’m thinking that I would do this in VB code and set it in the lost focus event of the textbox. I’m not sure how to code it.
Any help would greatly be appreciated.
Thanks.