flexgrid remove item after database delete

[clientuser]

how do you delete an item from a flexgrid after you have deleted it from a database?

i tried the refresh on the flexgrid but no good.

 

[ZOR]

In refresh I don't know whether it just redraws it? The grid needs to be reloaded with the recordset.

 

[PatrickIRL]

Much more to it than that. The way to do it, when you click on the grid to highlight the record, store the MouseRow value (assume the variable is called mRow).This happens on the MsFlexGrid1_Click event. When you want to delete the row then do the following.

With MsFlexGrid1
  .Row = mRow
  .RemoveItem mRow
End With

Patrick