Where do I put the count?

  • Thread starter Thread starter Ron
  • Start date Start date
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
 
Set the coontrol source property of a textbox to the right of your command
buttons to
=DCount("*","QueryName")
 
Back
Top