Annoyingly I did try that, and it is like that now, but for some reason it wasnt working, and now it is, I guess thats because I was still in debug mode and the sql hadn't been regenerated!

also, I tried to put "Debug.Print sqlSearcher" before, and after the highlighted erroneous line, however it didnt work, the intermediate window is open but that it didnt show the statement and values. Now I did enter into the immediate window "?sqlSearcher" and that returned my sql statement as its being processed, am I doing something particularly wrong?