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.
Title is in short text format in the table
text 89 is unformatted....but contains text
Any help is greatly appreciated.
The first part of the dlookup works ok...the second part after "and" seem to generate the error.
Code:
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.