adodc recordset update

[patbb]

I have an adodc control on a form and all my textboxes are bound to this adodc.
Then when I insert a new record to my Table, I used the coding as follows: adodc1.recordset.update

The problem is that it inserts the record at the end of my table in my access database but in adodc recordset it is not at the end.
why this and what's the solution.

thanks

[evaleah]

What makes you say it is not at the end? If, after adding the new record, you later adodc1.recordset.movelast is should go to the new record since that is now the last record.

I am not sure I am really answering what you are asking. If not, please reply and we can try again.

Eva

[moonguy]

try using
adodc1.refresh OR adodc1.recordset.resync after u update.