Try using Refresh . That should update the recordset.
james

"Apek" <dzulhelmi@my.flextronics.com> wrote in message
news:3d210a99$1@10.1.10.29...
>
> hi..how to update certain recordset??let say i have a combo box that allow
> user to choose one item..when user choose one item it'll make a text box
> display certain record base on what they choose from the combobox..my
problem
> is,how can i update the value in the textbox so only the recordset(the
textbox
> datasource)is updated?i use ADO as a connection..i tried
this,adodc1.recordset.update
> but it only update the first record..not the record that i want...please
> help me...