[RESOLVED] MSFlexgrid Refresh (?) or Redraw (?)

[ejpotpot]

Hi,

I have an MSFlexgrid grid displayed initially sorted by student ID. In the display, I have a sort command button for LastName sorting. The problem is i can't refresh the display after clicking the sort button.

Thanking you in advance.

Here's my code:

-----------------------------------------------------------
Private Sub cmdSort_Click()
    varSortBy = "LastName"                    ' varSortBy is global var
    Call Form_Load
End Sub
 
-----------------------------------------------------------
Private Sub Form_Load()
      
    If varSortBy = "" Then
      
       'Initial Form Load
 
       varSortBy = "s_id"
       MSFlexGrid2.FormatString = "Test"
       Data2.DatabaseName = App.Path & "\Student.mdb"
       Data2.RecordSource  = "Select * FROM Projects ORDER BY " & varSortBy
    
   Else
   
      'Called from sort button
 
       varSortBy = varSortBy
       MSFlexGrid2.FormatString = "Test"
       Data2.DatabaseName = App.Path & "\Student.mdb"
       Data2.RecordSource = "select * FROM Projects ORDER BY " & varSortBy
                                   
       MSFlexGrid2.Refresh
 
     End If
                       
End Sub

[dglienna]

Bound controls are evil, and hard to use. I always load the flexgrid myself. If I requery, I just clear the grid and call the reload method again. It may be a little bit slower, but I have full control over the formatting, color, and alignment of each cell in the grid.

[brucevde]

Call the Refresh method of the Data Control not the FlexGrid or use the Sort method of the FlexGrid and avoid a requery.

[anguswalker]

There are particular peculiarities of the MSHFlexGrid in terms of changing the underlying recordsource in any way. I wittered on about them a bit in this thread. Basically, using Set MSHFlexGrid.Recordset = ... seems the way to go.

[ejpotpot]

Thanks a lot BruceVde. It's working now.

Call the Refresh method of the Data Control not the FlexGrid or use the Sort method of the FlexGrid and avoid a requery.