total record in each Query to be show in the Main Dashboard form

[YaseenIskaf]

Dear All

I have a database with many Quires I want to create in the main form “welcome Form” many txt boxes cells
To show a total records in Each Quires
For Example I have the below list queries

1. Expired Employees Passport
2. Expired Employees Work Permit
3. Expired Employees Visas
4. Expired Employees Insurance

In the “Welcome Forms” I will create a txt boxes Cells for Each one of those Queries to be Show only No “total Record in Each one”
It is like a dashboard to monitor daily without opening the Report or Query

So, can I get a help

Thank you All

[YaseenIskaf]

[pbaldy]

You can use a DLookup() function, or perhaps eliminate the queries and use DCount() or DSum().