Report slow to generate!!

[johndoh!!]

My database is split FE/BE, the BE being located on a local server. I have a report with a subform that also has it's own subform and it can take a very long time to print. The windows task manager will say not responding but if i wait it will eventually print. This same report used to print fine before i split the db, why is that?

The two sub reports are based on tables, not queries, but the reports use the entire row (for one it uses a number of rows) so i wouldn't think being based upon a query would speed them up. Again, it worked fast prior to splitting the db.

Any help would be much appreciated.
Doh!!

 

[johndoh!!]

Don't i feel stupid!!

Those darn DLookup()'s will kill you won't they!!!!!!!!!!!

I had two of them for each line in a subreport that would have the highest number of hits to the db, dead slow!!

So for the rest of us noobs don't use DLookup() !!!

Sorry for making a mess of this great board.

Doh!!