The databse I'm working on inputs students. I was wondering if there was a way for my database to check "First Name", "Last Name" and "Student Number" when inputted to see if that studentis currently in the databse.

Thanks for your time.

Why not set the student id number to: Yes (no duplicates), as many students do have the same name.

Ian

You can do a Dlookup to check for duplicate name, and you wouldn't be able to enter a duplicate student ID, if that's the key. But I agree with ian_ok, a duplicate name is certainly possible.

thanks guys you're right...
thanks