Display table instances on a Form

[mikehextall]

I have an access database which records stationery orders made by different departments within the business, once the order is complete a combobox is used to set the status of the order to "Pending" once this is done the Facilities manager will open the database and extract the "Pending" orders and place the orders with the supplier.

What I want to do is to display on the Main form of the database exactly how many "Pending" orders there are upon opening the database, I envisage this being done with a textbox/label simply displaying a figure which is a count of the "Pending" orders. Once the order is place the status will be altered to "Completed" and should no longer show as Pending on the main form.

Can anyone advise how this could be done?

Thanks in advance

 

[pbaldy]

One way

=DCount("*", "TableName", "Status = 'Pending'")

Adjusting the table and field names as appropriate.

 

[mikehextall]

Works a treat, Thanks!

 

[pbaldy]

Happy to help, and welcome to the site by the way!