ADO Problems

[paddlefoot]

Heres the deal,

Say you got a form, with a bunch of
textboxes,or whatever, bound to a data
base. (i.e. txt.datafield = accountnum
txt.datasource = adodc1)

now, calling adodc1.recordset.addnew
should append a new record, (which it
does) and blank out the textbox for
new data (which it does). Here's the
problem, when i fill the textbox with
new data, and then call
adodc1.recordset.update it gives me
an error. (the data is in the correct
format...im sure of it). Furthermore,
according microsofts msdn, when youve
called addnew, a subsequent call to add
new should automatically call update,
update the db and put you into add records
mode agian. IT DOES!!!! (with no errors)
so in conclusion, two addnews will update
the first addnew, but one addnew and an
update gives me the following error:

"provider called a method from IROWSETNOTIFY
in the consumer and the method has not yet
returned"

Also, the db is ACCESS 2000 using
ms jet 4.0 (or 4.1...cant remember)

[Clunietp]

Just do two ADDNEWs, and then a CANCEL. The cancel will null the last ADDNEW (theoretically)