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]