hi all ,

i have daragride view connect to Access data base, my question is that, how i can delete a specific row when i click on it from datagride and database ????
this is a data grid ...



when i click in the spacific row i will get msg box of the clicked row ....

from this code

Code:
Private Sub DataGrid1_RowColChange(LastRow As Variant, ByVal LastCol As Integer)
msgbox DataGrid1.Row  ' the row number 

msgbox DataGrid1.Columns(3).Text

End Sub

please help me out to delete a record when i click a specific row ??????



also how i can reuse a ID number in the database ??????

best regards