C'mon have a look at this will ya!!

I need some help..
I got an SQL string (i think it works) to be executed as a query search on a table but i cant get the msflexgrid to refresh or the data control for that matter. This is the code:

Dim SQL As String
SQL = "Select * from [cd_serial_numbers] where [band_name] = '" & txtband.Text & "'"
Let Data1.RecordSource = SQL

Data1.Refresh
MSFlexGrid1.Refresh
Data1.Refresh


MSFlexGrid1.DataSource = Data1
MSFlexGrid1.Refresh

which lines of code do i need and which don't i need?

Please i am desperate....