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.