Report formating Taken long time

  • Thread starter Thread starter Comrade
  • Start date Start date
C

Comrade

I have a report with Dlookup textboxes and any time I am opening the
reports it takes a long time to open, how can I improve on the speed
of the reports. I have indexed the fileds on the source tables
 
Find a way to get rid of the DLookup. In most cases, you should be able to
add the relevant table to an underlying query that you are using for the
source of the report.

DLookup's basically run a query each time they are called. So if you have two
DLookup's in the detail section, you are going to run two queries for each
detail line of the report. Not very efficient.

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County
 
If you can use DLookup() it generally add a table or query to the report's
record source and join the fields used in the where condition of the
DLookup().

If you can't figure this out, you need to provide some information about
your report's record source and the DLookup() expressions.
 
Back
Top