Can anyone tell me how to update the record to the database. Well it only update the forst record but not the second one. My code is as follow: -

frmhistory.data3.recordset.edit
frmhistory.text2.text=text3.text frmhistory.data3.recordset.update

adodc2.recordset.movenext
if adodc2.recordset.eof = true then
command1.enabled=false
end if

well the purpose of the edir is to show only the specific record i choose which is then update to the db and then view the report.

Thank in advance if someone can help me