Where do I put the count?

R

Ron

Hi All,

I use a form to hold 4 command buttons that run separate reports. The
reports are based on querys. I have a control to the right of each cb
that I want to indicate how many records are in each of the queries so
the user can decide for themselves whether to run the reports or not.
How can I show the total records in each of the queries to the user
before they have to select the report.

I know I can put a nodata routine in the report itself, and I have
that. Just thought it would be good to list the number of records on
that form so the user doesn't even have to click the cb for the
reports having no records.

TIA
ron
 
R

RonaldoOneNil

Set the coontrol source property of a textbox to the right of your command
buttons to
=DCount("*","QueryName")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dumb question alert! What program to use? 0
Active Content in this file is blocked issue 1
Need some PWA help 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Doughnut Chart linked with the slicer in the pivot table 0
Access 2002 change report header text 0
Cannot Put A Border Around Numbered Text. What To Do? 0
Office 2010 SP1 Broke My App 0

Top