When we using DAO, sometimes we need insert a record into database order by one filed.How to do it?Follow these steps:
Dao.recordset rc;
At initiation, you must select from table order by the field which you want to sort by:
Select * from table order by field;
When insert, after update method.You call requery method:
rc.Requery;
And finally you find the record you have just insert by .FindFirst.
No comments:
Post a Comment