DLookup question

[Aidan]

I have a query that returns a list of records sorted by date/time descending.
The first record in the query will be the most recent.

In a form for data entry I want to select the values from the last instance of data entered using Dlookup to select the first record frm the above query, something like:

DLookup("[Field]", "Query", criteria to select the first record from the query)

Any ideas?

Thanks

[NeoPa]

One option is to use :

DFirst('[Field]', 'Query')

But if you prefer, you can use the TOP predicate in the SELECT clause of the query to return only the first record :

SELECT TOP 1 ...