DLookup in ADO codes (Microsoft Access Error Message)

DLookup in ADO codes
message from =?Utf-8?B?UGV0ZXI=?= on 19 May 2004
I use ADO to open a cursor. Can I use DLookup to find the first record in the cursor?

Kailash Kalyani replied to =?Utf-8?B?UGV0ZXI=?= on 20 May 2004

In a given recordset you can easily go to the first record by using the
recordset's movefirst method.
Try reviewing the MSDN for the recordset object
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/mdobjodbrec.asp

Hope that helps.

=?Utf-8?B?UGV0ZXI=?= replied to Kailash Kalyani on 20 May 2004

Thanks. The purpose I want to use DLookup is because the target row may not be the first row of the recordset. It can be any row.

Brendan Reynolds replied to =?Utf-8?B?UGV0ZXI=?= on 20 May 2004

The answer is no, Peter, the second argument ("domain") to the DLookup
function must be the name of a table or query, it can not be a reference to
a recordset. Recordsets have their own methods of searching and filtering
instead: Find, Seek, and Filter for example.

Archived message: DLookup in ADO codes (MS Access Forms)