Someone please help!!!

See code below

Data4.Recordset.Edit

Data4.Recordset("rate of pay1") = Val(txtrop1)
Data4.Recordset("rate of pay2") = Val(txtrop2)
Data4.Recordset("max pay") = Val(txtmaxpay)

Data4.Recordset.Update
the update doesn't seem to be working, when I display
Data4.Recordset("rate of pay1") after the update I get the old value.
NB when the update line executes the program goes to
Private Sub data4_Reposition(), I put the Debug.print statement with Data4.Recordset("rate of pay1"), in the beginning of this sub and here it is already showing the old value.

What am I doing wrong, or where should I do the update

Thanks in advance guys