Dlookup Type Mismatch Error

[ria4life]

I keep getting type mismatch error with this code.
The first part of the dlookup works ok...the second part after "and" seem to generate the error.

Me.I1 = DLookup("Occurance", "[Qry_Availability1]", "Date_Selected = Sig1" And "[title] = '" & Text89 & "'")

Title is in short text format in the table
text 89 is unformatted....but contains text

Any help is greatly appreciated.

 

[pbaldy]

The quotes on both sides of And need to be deleted.

 

[ria4life]

WOW Cant believe it was a simple as that.
thank you much

 

[pbaldy]

No problem, though I don't quite understand the date criteria.

 

[mresann]

You may wish to put "Solved" in the title as well.