I am perfroming a multiple criteria search that sometimes does not return the criteria searched for. For one of my criteria in my query, i am using
IIf(IsNull([Forms]![Form3]![text1]),[Thesis_Title],IIf(InStr([Thesis_Title],[Forms]![Form3]![text1])>0,[Thesis_Title]))
When i search for a set...