I posted the explanation in post #13

The first mesage box is because of an instruction I wrote in the code, just to display the content of the sql query,remove it anytime you want...
The instruction to remove is : MsgBox strSQL

The second message is the error
The reason for this error are the single quotes characters ['] that are included in the paragraph that you click in the list box... example ("and weave the spider's web...") the error is caused by the ' character in spider's

Let me search for an alternative to find a record using single quotes in the text