Hi!

What error message you get?
What type field "field" have in the database?

>Hi, folks!
>
>I´m having a problem with ADO, I try to set the value of one field in the recordset, but i get an error! The value from the textbox doesn´t goes to the filed in the recordset. Take a look:
>
>*********
>...
>adRecordSet.fields("field").value = ALLTRIM(ThisForm.textbox.VALUE) && <- ERROR!
>
>adRecordSet.update
>...
>*********
>I opened the recordset with this command:
>
>#DEFINE adOpenDynamic 3
>
>adRecordset.OPEN("select * from schema.table order by field",adConnection,adOpenDynamic) && asConnection is an open connection to an
> && Oracle 8.1.5 Database.
>
>Any help is welcome!
>
>Tia.
>
>Alonso.