I have a form with an ADO control on it and a couple of text fields. Everything works fine except once I add a new record using my add button and enter text in the text fields how do I make the ADO control update the underlying database with the text. Because if I move around using the ADO control I find the underlying database hasn't been fully updated. Example is the autonumber field (in my Access 97) database is blank, and if I try to requery the recordset I find the new data has dissappeared.

If I add a new record then the old record seems to be placed in the underlying recordset.

I hope I make sense here. Also is the best way to ensure the records are always ordered by one of the text fields having a SQL statement with ORDER BY in it and the requerying the recordset when any data changes, or is there a simpler way? Thanks