Progress Form

[dakotauk]

I am trying to create a form that can be opened and on it will be the progress of a project.

I want to count the rows/records in each query and make them available on one form, and update each time the form is opened.

ie

Completed : 10 products[records/rows]
Missing: 5 products[records/rows]
Needs Checking: 11 products[records/rows]

Any ideas?

Thanks in advance if you can help.

 

[MajP]

Take a look at the dcount method, but you are going to have to provide some more details to get a better answer.