Can anyone answer this question? I have a form which displays student information. The primary key is the student's SS number. When I enter the SS #, I want the form to display information in the other fields if the student is already in the database. Do you do this with a macro?