Using the 'Count' function in a totals query

[sjs94704]

OK, I have a database that manages Work Orders. There are 7 statuses that each work order could possibly be in. They are:

0 - NEW
1 - Open


2 - WIP (Work In Progress)
3 - Serviced
4 - Reviewed
5 - Followed Up
6 - Closed

I have several menus for Admin, Manager, Supervisor and Technicians. I have 7 textboxes on each of these menus that are all grouped together to display the count of how many work orders are in the system for each status. I have totals queries for each status that use the Count function to get the total number of work orders, but having trouble knowing how to get those numbers to show up in the text boxes....HELP !!

The work order table has a lot of fields in it so I won't list all the irrelevant ones here, but the fields that are important are:

WorkOrderT (Name of Table)
WorkOrderID
CustomerID
StatusID

Suggestion on how I can do this?

[June7]

Why do you have separate queries for each status? One aggregate query can return the count for all status. Why have 4 forms (menus)? What is different between these forms that one won't serve? Bind form to the one aggregate query and bind textboxes to the fields.