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....

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.)

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"EricB" <(E-Mail Removed)> wrote in message
news:6A8D5E0D-2550-4BD3-B326-(E-Mail Removed)...
>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....