Dlookup and multiple criteria error

[Marcel2586]

I have a problem with my dlookup statement. When i run it separately there are no errors and I get my results but when I combine them together with AND I get error runtime error ‘13’: Type mismatch.
All tables are text.

This is the code that works

DestTAT = DLookup "[TAT]", "tbl Dest TAT", "[MAT]= '" & MatStr & "'"

DestTAT = DLookup "[TAT]", "tbl Dest TAT", "[Destination]= '" & Znumber1Str & "'"

This gives the error

Public Function DestTAT(MatStr As String, Znumber1Str As String) As Variant
 
    DestTAT = DLookup("[TAT]", "tbl Dest TAT", _
    "[MAT]= '" & MatStr & "'" And "[Destination]= '" & Znumber1Str & "'")
End Function

Thanks in advance

 

[MStef]

Try this:
....... MatStr & "'" & "And [Destination]= '" & Znumber1Str & "'")

 

[Marcel2586]

Many and many thanks.
You saved the day. (mine at least)