Re: Subreport or DLookup?

I'm rewriting stuff and I'll import a ton of data into all
the tables and then I'll try it both ways under the clock. Plus, I'm going
to try some subqueries as well to see how that effects speed for this type
of thing.

The reason I asked the question in the first place is that I've written it
with the subreports option and it just seems "slow" looking. Thought I'd
ask the question and if people had lots of experience going one way over
another, I'd find out here and wouldn't have to work so hard. ::grin::
But, I guess I need to experiment--not a bad thing.

Thanks for your response, Larry. I appreciate your time.
ron



"Larry Linson" <bouncer@xxxxxxxxxxxxx> wrote in message
news:nZ2fg.6188$%C6.3544@xxxxxxxxxxx
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





.