StrSQL3 = "SELECT * FROM EnrollmentInformationTable " & _
"WHERE (((EnrollmentInformationTable.EmployeeSSN) = " & Forms!UpdateForm!temp & ") " & _
"AND ((EnrollmentInformationTable.EmployeeLastName) = """ & Forms!UpdateForm!EmployeeName & """));"
I'm getting the error message: "Data type mismatch in criteria expression."
Can anyone help me out?
"WHERE (((EnrollmentInformationTable.EmployeeSSN) = " & Forms!UpdateForm!temp & ") " & _
"AND ((EnrollmentInformationTable.EmployeeLastName) = """ & Forms!UpdateForm!EmployeeName & """));"
I'm getting the error message: "Data type mismatch in criteria expression."
Can anyone help me out?

Last edited: