record count

[seeker52]

I receive an error 3464 when I put =count(*) in the controlsource of a
textbox on the report header. The error is thrown at the filter
created for the report when I docmd openreport. The error is not
thrown if the =count(*) is not used. I want the textbox in the header
of the report to show the number of records in the report.

seeker53

[Allen Browne]

Make sure the text box is in the Report Header section, not the Page Header
section.

Try adding quotes, e.g.:
=Count("*")

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"seeker52" <ak*****@hotmail.com> wrote in message
news:8c**************************@posting.google.c om...

I receive an error 3464 when I put =count(*) in the controlsource of a
textbox on the report header. The error is thrown at the filter
created for the report when I docmd openreport. The error is not
thrown if the =count(*) is not used. I want the textbox in the header
of the report to show the number of records in the report.

seeker53