Dlookup on two fields

[b31luv]

This is my code

Me.ProjectName = DLookup ("ProjectName", "[ProjectInfo]", "[ProjectInfo].ProjectNo = '" & Me.ProjectNumber & "'" And "[ProjectInfo].TaskNumber = '" & Me.TaskNumber & "'&quot

Everything is a text value.

I keep getting Type Mismatch

I looked at this thread 702-695680 and it suggest writting the code exactly the way I have. Can anyone help me solve this?

 

[b31luv]

I got, I had too many double quotes.

Me.ProjectName = DLookup("ProjectName", "ProjectInfo", "ProjectNo = '" & Me.ProjectNumber & "' And TaskNumber = '" & Me.TaskNumber & "'&quot

Removed the double quote before the "And" and after the "AND"