to edit u need to use update
here is an example
Code:
Private Sub cmdupdate_Click()
Dim cn As New ADODB.Connection
Dim rs As New ADODB.Recordset
cn.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data source=D:\NYSPlacementDatabase\NYSPlacementDatabase.mdb;"
Dim sql As String
Dim container As Integer
container = CInt(txtID.Text)
sql = "select * from PostApplicant where Post_ID=" & container
rs.Open sql, cn, adOpenDynamic, adLockOptimistic
rs("Post_ID") = txtID.Text
rs("FirstName") = txtFirstName.Text
rs("LastName") = txtLastName.Text
rs("Post_Age") = txtage.Text
rs("PhoneCell") = txtPhoneCell.Text
rs("PhoneFixed") = txtPhoneFixed.Text
rs("Address") = txtAddress.Text
rs.Update
MsgBox ("Update successful")
cn.Close
End Sub