In DAO when finding data it is possible to use the .FindLast method to find the last matching record.
Does anyone know a simple way to code this using
.Find in ADO ?
Printable View
In DAO when finding data it is possible to use the .FindLast method to find the last matching record.
Does anyone know a simple way to code this using
.Find in ADO ?
Hi Paul
All you need to do is
recordset.FindLast "Fieldname = 'ABC'"
and it will search fom the last record backwards.
The Field just has to be in the recordset your searching
Hope this helps
Ian