My program allows users to create new records by clicking a command button. A series of input boxes appear so the user can enter the details. However, for the first input box, I want the user to enter a ColleagueID record, and if it exists, it will ask the user to try again.

How do I make such a check? Using SQL?