I am stuck on the following code. I keep trying to make changes to it and continue to get errors. The code listed below gives me a type mismatch error. (I have seen syntex errors also)
Any suggestions on what I am doing wrong? (The Code is text, EmpNum is a number and the other is a date. I have checked the tables this relates to and the formatting matches)
Code1 = DLookup("[Code]", "Attendance Data", "[EmpNum]= " & Forms![Warning Data]!EmpNum & """" And "[AttendanceDate]= #" & Forms![Warning Data]![AttendanceDate1] & "#")
Thanks for all of your help
Jessica