Counting records in a query

[pmo]

I have a form that consists of several sub forms. Thanks to "solodroid" I have been able to display in a text box the number of records that appear in a form.
Is it possible to do similar with a query that may not necessarily relate specifically to one of the forms that is opened.

I often refer to forms by using [Forms]![FormName]![Field] can you do similar with a query (if so how do you request a particular record?

In anticipation of your help.


Wayne

 

[seaport]

You may just put the following code in the form_current event procedure:

[Forms]![FormName]![Field]=dcount("*","queryname&quot

seaport

 

[realm22]

Many Thanks It works Great. First Time I needed the Process Bar.... Mike