Query count on a form?

[sdavid74]

Is there a way that I can display the record count in a certain query on a main form page?

I have a main page that I use to navigate among query results, forms, and reports, and, from that form, I would like to display how many records are in each query.

 

[WildHare]

A query doesn't have any records in it until you run it, so the number may vary. I suppose you could program a small button to do a DCOUNT of the query's recordsource on demand:

x = DCOUNT("Select ... from ... where... &quot etc etc..

In other words, the only way to see how many records a query will return is to RUN that query - and then check the dynaset that results. A query itself doesn't hold data - it RETURNS data.

Jim How many of you believe in telekinesis? Raise my hand...
Another free Access forum:

http://www.forumco.com/jmhare

More Access stuff at

http://www.jmhare.com/wildhare2.htm

 

[sdavid74]

thanks...that explains some strange results I've been getting