Im using VB 6.0 and Crystal Reports 7.0, and running the query command

Crystalreports1.SQLQUERY = "SELECT * FROM Table1 WHERE item=item1"

when I print the report I still get the entire database (that is all the items item1 - item100)

Does anyone know why? Is this a VB syntax error or a Crystal Reports design error?

Please help.


Thanks

TB