Q: Downloaded Database Tip Hi! I downloaded a file that you have in the database tip section, the tip file was called "Search for a word in all text fields". My question is you have a place for the user to place a check mark and reading the code I cannot figure out what the check mark is suppose to do. I have searched with it and without it but seem to get the same results. Could you please explain the two dummy search sections of the code and the difference, Where and or, Seems like i am getting the same search results. Thanks, Phil Philip Price; phillipprice@mindspring.com A: the chechmark is for checking on 'whole words only'. That's way the the code is different: the first check is for exact match; the second (with the LIKE keyword) is for match any.. If frmFind.Check1.Value = 1 Then If blnFirst Then strDummy = strDummy & " WHERE (" & rs.Fields(intX).Name & " = '" & strZoek & "')" blnFirst = False Else strDummy = strDummy & " OR (" & rs.Fields(intX).Name & " = '" & strZoek & "')" End If Else If blnFirst Then strDummy = strDummy & " WHERE (" & rs.Fields(intX).Name & " LIKE '*" & strZoek & "*')" blnFirst = False Else strDummy = strDummy & " OR (" & rs.Fields(intX).Name & " LIKE '*" & strZoek & "*')" End If End If BTW; It was not supposed to be in the example... Return