-
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
-
In your add button code I expect you have a recordset.addnew, but have you got a recordset.update after you have set the fields. Because if you haven't you will get the problem that you are saying.
Hope this Helps
Ian
-
Thanks
I tried it and it works perfectly
