Changing MsFlexgrid DataSource at runtime

[Nemachtiani]

Is it possible to Change the Datasource Property of a MsFlexgrid at run time?
How can i do that?
Nemachtiani

[Chris]

Just do it in this way

Private Sub Command1_Click()
Set MSFlexGrid1.DataSource = Data1
MSFlexGrid.Refresh
End Sub

Private Sub Command2_Click()
Set MSFlexGrid1.DataSource = Data2
MSFlexGrid.Refresh
End Sub

Or you can do this by changing the Data control [RecordSource

Private Sub Command1_Click()
Data1.RecordSource = "SELECT * FROM <New Table>;"
Data1.Refresh
End Sub

[Edited by Chris on 06-25-2000 at 12:34 PM]