is tis possible?

I am want to use a Input box to set the WHERE clause in a SQL statement I tried using for example:
strSQL="SELECT * from SHAPES WHERE color =Search$" but it will not recognise the value in Search$ is this possible or is there any easier way to do this .When I run in debug mode the Search$ contains the value I want but not when I add it to the sql

Mike

If Search$ is a variable in your application you need to try something like this:

strSQL="SELECT * from SHAPES WHERE color = '" & Search$ & "'"

Note the single quote characters surrounding the Search$ variable.

Thanks Glenn I will give that a try what is the purpose of that & symbol before and after the string?

String concatination operator.

Many Thanks worked like a charm You saved me what little hair I have left