how do i update a field in a recordset ?

hi! i have a database with a idnumber, timein, timeout how do i search for the idnumber and then updating the timeout value of that particular recordset? im using access and my connections are not hardcoded what i usually do is just using the adodc for moving the file then click on the textbox that needs to be updated please help im not very good at this ..

Can you clarify this "click on the textbox that needs to be updated..."

Try using a SQL statement for searching the IDNumber or if you want, use a combobox to dropdown all the IDNumbers and select you want to update.

I came up with these simple code:

Rey Sean

Can you clarify this "click on the textbox that needs to be updated..."

what i meant was i just edit the textboxes then click on recordset.update and thats how i update it...

tnx for the code it help i didnt now i could use recordset.save sorry for being so noob :)

i'm not sure on what the proper syntax for searching the field ? its an idnumber
do while recordset.eof

if textidnumber = recordset.fields(0).value then
<code for update here>
else
recordset.movenext
end if
loop

IS this right?
any suggestion on improving this thanks

The IDNumber should be your primary key and you cannot update it.

Here's the code for searching the IDNumber

Try to finish it. I know you can do it. :)

The IDNumber should be your primary key and you cannot update it.

ooww i see i guess that was my problem because the idnumber is not my primary key. may table goes like this logid pk, idnum, timein, timeout
i guess what i should do is finding first the idnum and take the value of the logid my primary key then searching it again. so that i can update it? i'm not sure if my approach is right just giving a head's up on the primary key issue

i've got the updating correctly now thanks to you.. :) my problem is now i can seem to see immediately the newly added data dont know why this is i tried refresh and requery but it doesnt work any help on this?

Sorry people, I've had to clean out quite a lot of this thread. TheScripts allows posting only in English.