Hi. I have the following fields in my table tblStudents:
StudentID - AUTONUMDER (PRIMARY KEY)
ADM NO - Short text
LAST NAME - Short text
FIRST NAME - Short text
I want to prevent duplicates if ADM NO has been entered.
Msgbox "Sorry ADM NO is already in use by LAST NAME and FIRST NAME"
THANKS.