Source line: rs.Open SQL, conn Description: Data type mismatch in criteria e?

I can't tell for sure from this code, but my guess would be that the studnum field is numeric, but in you code you are putting double quotes around it which makes it a string. That's why you are getting datatype mismatch, the database is expecting a number but you are providing a string.