Harrild
Jul 15th, 2000, 01:33 AM
This is a button in one of my programs
Private sub bandsearch_click()
Dim bandsql As String
bandsql = "SELECT * From CD_SERIAL_NUMBERS WHERE (Band_Name='" & txtband.Text & "')"
Let Data1.RecordSource = bandsql
Set MSFlexGrid1.DataSource = Data1
MSFlexGrid1.Refresh
Data1.Refresh
end sub
do i need 'Set MSFlexGrid1.DataSource = Data1?
or 'MSFlexGrid1.Refesh?
or 'Data1.Refresh?
But the point is- how do i refresh the grid once i've executed the SQL?
Private sub bandsearch_click()
Dim bandsql As String
bandsql = "SELECT * From CD_SERIAL_NUMBERS WHERE (Band_Name='" & txtband.Text & "')"
Let Data1.RecordSource = bandsql
Set MSFlexGrid1.DataSource = Data1
MSFlexGrid1.Refresh
Data1.Refresh
end sub
do i need 'Set MSFlexGrid1.DataSource = Data1?
or 'MSFlexGrid1.Refesh?
or 'Data1.Refresh?
But the point is- how do i refresh the grid once i've executed the SQL?