Hey all,
This one's probably pretty easy, but I can't seem to find the right search term to find my answer. I have a form that is designed to insert new students into a database. The form is pretty long, and doesn't check to see if the primary key (StudentID) already exists in the table until the entire form is complete and the record created.
My question is this: can I create a validation rule for the StudentID field which will check whether or not the student already exists before allowing the rest of the form to be filled out? I'm thinking of a Lost Focus event that will check the value, see if it already exists in the table, and protest if it does exist. What would the validation rule be?
I'm pretty new to Access, but I've done some previous programming. Any help you can give would be greatly appreciated.