Flexgrid

[mel_flynn]

I need code that will delete the line highlighted by a user in a MSFlexGrid.

I've tried :

MSFlexGrid1.removeItem

But the program is looking for an index number.

[GlenW]

With myGrid
If (.Row = .RowSel) Then
     .RemoveItem (.Row)
Else
      MsgBox "You can only remove one record at a time!", _
                   vbInformation, _
                   "Delete"
End If
End With

This allows 1 row to be deleted

[GlenW]

Guess my code didn't work.

[mel_flynn]

Yes the code works ... in the sence that the row is removed from the Grid, but doesn't delete it from the database.

How do I delete it from the data source aswell???

[GlenW]

Choice 1 : In code using ADO where you got the data from in the first place.
Choice 2 : Bind the grid to the data. (bad idea)

[mel_flynn]

How do I do this?

Choice 1 : In code using ADO where you got the data from in the first place.