update certain record

[Apek]

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...

[james]

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...

[Per]

Hi
I had the same problem 2 days agoe, I've sloved it by first close the connection
(after the update) and then in the next line open the connection. This is
not nice but it worked, amd if the db is small you will not notice it.

"james" <jamesw2@mesh.net> wrote:
>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...
>
>