displaying qry data on a form

  • Thread starter Thread starter jonudden
  • Start date Start date
J

jonudden

On the main form,(switchboard), I have an unbound text box and I wan
it to display the number of records in the database, based on
query. I thought it was something lik
=qryName!qryCoun
but obviously that wasn't correct... Any ideas
 
On Fri, 15 Jul 2005 03:35:46 -0500,
On the main form,(switchboard), I have an unbound text box and I want
it to display the number of records in the database, based on a
query. I thought it was something like
=qryName!qryCount
but obviously that wasn't correct... Any ideas?
Click to expand...

A "database" contains multiple Tables, Forms, Reports, Queries, and
other objects. The statement "number of records in the database" is
essentially meaningless.

If you want the count of records in a Table, you can use

=DCount("*", "[tablename]")

as the control source of a textbox. You'll need to requery the textbox
in any event which adds data to the table if you want the number to be
current.

John W. Vinson[MVP]
 
Back
Top