Hi

I am writing yet another database, this time for Sales to create deal sheets. The first form after login is a "Status" page where i have headings that have counts of each status of where a deal is. I have tried using DCount in the control source of each text box aswell as using a query for each count and then putting it all the queries into one and assigning the main query to the form then selecting the relavant query in each control source. Both instances causes the page to load for a really long time.

Is there a way to have a status page with the data up to date and the page loads quickly?

Thanks