Re: Subreport or DLookup?

The only way to know for sure is to try both. Both Subforms and DLookups can
be surprisingly speedy or dead-dog slow, depending on factors that are
difficult to determine. (My _guess_ would be that Subforms were faster,
particularly if you are able to limit the contents using an indexed field,
but it's only a guess.)

Larry Linson
Microsoft Access MVP

"Ron" <ronSPAMBLOCKERwest777@xxxxxxxxxxxxx> wrote in message
news:_g2fg.13$jB5.11@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
Hi All,

Was just wondering which is faster, a subreport or dlookup.

I've got a report with either 5 subreports or lots of dlookups. The
subreports generally have anywhere from 5 to 12 controls on them so if I
don't do the subreport thing, I'm doing TONS of dlookups.

Just wondering what others have found to be a faster way to do things. Is
there even a faster way I'm unaware of yet than these 2 options?

Thanks in advance for any help,
ron



.