I have a form that is based on a query. The form is a vertical colume
layout format. Headers for each colume and then the data is displayed
below it.

I have a control on the Header of the form that I want to display the
total number of records that were returned from the query. How would I
do this?

Everything I try either comes back as #ERROR or #NAME?.

Any on ehave any ideas?

Michael Charney


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Michael,

Put the following expression in the OnOpen event of the form:

Me!NameOfTotalsTextbox = Me.RecordsetClone.RecordCount


--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
www.pcdatasheet.com


"Michael Charney" <mbcharney@sbcglobal.net> wrote in message
news:3f81bc28$0$195$75868355@news.frii.net...[color=blue]
> I have a form that is based on a query. The form is a vertical colume
> layout format. Headers for each colume and then the data is displayed
> below it.
>
> I have a control on the Header of the form that I want to display the
> total number of records that were returned from the query. How would I
> do this?
>
> Everything I try either comes back as #ERROR or #NAME?.
>
> Any on ehave any ideas?
>
> Michael Charney
>
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it![/color]

Might be pure fluke, but I got this to work:

=DCount("[MS_WANC]","Query1","1=1")

Query1 is the object the form is based on, "MS_WANC" is a field in the query...

Michael Charney <mbcharney@sbcglobal.net> wrote in message news:<3f81bc28$0$195$75868355@news.frii.net>...[color=blue]
> I have a form that is based on a query. The form is a vertical colume
> layout format. Headers for each colume and then the data is displayed
> below it.
>
> I have a control on the Header of the form that I want to display the
> total number of records that were returned from the query. How would I
> do this?[/color]

If the underlying query is called "qryMyQuery", then try pasting this
in an empty text box.

=DCount("*","qryMyQuery")

HTH

Regards
Stuart