Ok i got a button to execute a search and display the results on a flexigrid but VB doesnt like it for some reason.........Please help cos i have no idea where i have gone wrong.

Private Sub cmdSearchBand_Click()

Dim bandsql As String

bandsql = "Select * from cd_serial_numbers where (band_name ='" & txtband.Text & "')"

data1.DataSource = bandsql
data1.Refresh

End Sub


Could someone please tell me where i have gone wrong......