Re: Subreport or DLookup?

More important to your question is the fact that DLookup and subreports are
not substitutes for each other. If you have multiple rows of related data
to display, you're going to have to use a subreport.

Example: A customer can have many orders (order headers). An order header
can have many details (order lines).

If you want to print a customer and then a list of his orders, you must use
a subreport. There is no way with dlookup() to generate the multiple
linesyou would need to represent each of the lower level (order header)
records.

If this is similar to your task, the relative speed of dlookup and
subreports is not relevant.
.