My select statement did not work,,Pls help

[maqmaq]

When I run this sql:

mysql = "select * from cri where stock like '[89*]';"
Data1.RecordSource = mysql
Data1.Refresh

I am getting this error:
Too vew parameters, expected 1 (3061)

What could be wrong in my select statement, and how to learn the equation of putting the correct position of commas, punctuation, semicolon etc so I will not face this kind of problem

Please help
Appreciated in advance

[makai]

try

mysql = "select * from cri where stock like '89*'"

[maqmaq]

Same error occurred !!!!

[maqmaq]

What a mestake I was doing, The feild name was not completed, it was stock number not only stock,,,,I reaply the sql with the correct name and it work correct

Thanks for your particiption