Counting Records on a Form (short)

[Andy Korth]

This should be a short one...
I've got one of those fancy continous forms. In the
header, I'd really like a little text box that says:
"Now viewing 10 records."
Actually, I'd like it to just say 10- when there are 10
rows showing in my form, of course.

Anyway, the obvious solution here is DCount. However, it
doesn't seem to work having DCount in the control source
of a textbox. Any ideas?
The recordsource is a pretty long SQL string, with a
WHERE clause in it, so that needs to be in the DCount, if
that is the route to take.

Thanks a lot,
Andy

 

[Dirk Goldgar]

This should be a short one...
I've got one of those fancy continous forms. In the
header, I'd really like a little text box that says:
"Now viewing 10 records."
Actually, I'd like it to just say 10- when there are 10
rows showing in my form, of course.

Anyway, the obvious solution here is DCount. However, it
doesn't seem to work having DCount in the control source
of a textbox. Any ideas?
The recordsource is a pretty long SQL string, with a
WHERE clause in it, so that needs to be in the DCount, if
that is the route to take.

You *could* use DCount, if you set it up properly, but it's probably
simpler to use this as the controlsource for your text box:

=Count(*)

 

[Andy Korth]

Ha, perfect! Thanks a lot.
Count... works even better than DCount. Wonder how I
missed that one.


Andy