>I am using the flexgrid control 5.0 with a data control. I want to create a means to view a table chosen at runtime. I have done it static perfectly, its just when I try to change the data controls source that the grid doesn't update. I tried refresh, repaint, doevents... No error, just no data. Very frustrating. Help. all of the ancillary settings are set for fox 3 tables. When I manually set the following it works fine.
>
>
>Private Sub cmdAssignDatSource_Click()
> datFox.RecordSource = "BUSINESS"
> DoEvents
>End Sub
>
After changing the RescordSource property of a data control, you to refresh the data control (and if the flex grid is correctly bound, it will automatically be updated).
Private Sub cmdAssignDatSource_Click()
datFox.RecordSource = "BUSINESS"
datFox.Refresh
End Sub
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com