RE: Help

[yinyin]

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

[funkyd77]

It's a little bit confusing to see what exactly it is you are doing.

For example, How does "frmhistory.text2.text" or "text3.text" relate to the recordset?

you generally need to do something like this:

theRecordSet!NumberPeople = 5 'New value for field "NumberPeople"
theRecordSet.Update


ie, you need to assign some values to the fields in the recordset before you issue the update. Unless i'm missing something - I cannot see where you assign any values to any fields in your recordset.

...

[yinyin]

Originally posted by funkyd77
It's a little bit confusing to see what exactly it is you are doing.

For example, How does "frmhistory.text2.text" or "text3.text" relate to the recordset?

you generally need to do something like this:

theRecordSet!NumberPeople = 5 'New value for field "NumberPeople"
theRecordSet.Update


ie, you need to assign some values to the fields in the recordset before you issue the update. Unless i'm missing something - I cannot see where you assign any values to any fields in your recordset.

...

Well actually, the text3 is where i enter the value. After that i want to update whatever i enter in text3 to the frmhistory.text2.text. In other words, text3 is from the form frmadjust. I want to update whatever i enter in frmadjust to the frmhistory where i have a data control in that frmhistory form that is connected to the db table.

hope u can help me.thank