DCount slows down Access application.

[EricB]

I have a mainform where my users can see the nr of purchase orders that are
waiting for them to be processed. When the form is loaded or when the main
form is active the Dcount is triggered but it slows down the entire
application each time, is there an alternative for using DCount? I have about
5 dcounts in my mainform.
Thaks for any help or tips....

 

[Allen Browne]

Depends what you need done, Eric.

The domain aggregate functions will slow you down. Perhaps you can tell us
what's in them: it may be possible to use one totals query to get all the
values, and then assign them to unbound text boxes on your form (perhaps on
Form_Current.)