Access Lookup Problem

[Trob70]

I am having a problem with the following line


sql2 = "SELECT * FROM [wol] WHERE trim([Title]) = '" & Trim(TextBox4.Text) & "' and trim([publisher]) = '" & Trim(TextBox8.Text) & "' and trim(

) = '" & Trim(TextBox7.Text) & "' and trim([composer]) = '" & Trim(TextBox9.Text) & "'"



The problem is   The Textbox8.text  is eg isn't it  (for example)

ie  the is a  '    in the lookup

The program bombs out

is there a way of doing a lookup  with a  '   in texttbox i am using for the lookup


Appreciate any help


Trob70

 

[jbenson001]

First of all, I suggest you use stored procedures.
Second, you have to replace any single quote ("'") with double single quotes ("''")

 

[Trob70]

jbenson001

Thanks for your advice.....

Did not realize that ado had this problem Have allways been use Dao in vb6

Thanks for you advice

Regards Trob70

 

[jbenson001]

Glad to help.