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