When I run this command:

Private Sub Command7_Click()
'CRI is the table name
'stock is the field name
mySQL = "SELECT * FROM cri WHERE stock Like '[89]*';"
Data1.RecordSource = mySQL
Data1.Refresh
End Sub

I am getting this error:

Too few parameters. Expected 1. (Error 3061)
What could be wrong with it...

Any help...
Appreciated in advance

[Edited by maqmaq on 10-10-2000 at 09:30 AM]