I would like to open a form using 2 where conditions. I thought I could do this using AND or OR. Right now I can open it with either of the conditions I've typed in, but if I try to do both with AND in the middle, I get a "Type mismatch" error. Any ideas?
Code:DoCmd.OpenForm "Employee", , , "[Employee.LastName]='" & tempLast & "'" And "[Employee.FirstName]='" & tempFirst & "'"