I am trying to get the selected cell contents from a msflexgrid into an msaccess tbl. With this code it is added into the correct column, but as a new record.

Private Sub Command1_Click()

Text1.Text = MSFlexGrid1
query = "INSERT INTO Jobs (Progress) VALUES ('" & Text1 & "')"
Set rs = DBCon.Execute(query)
End Sub

How can I identify which record it belongs to, as in order to edit it the focus is in the one cell only.