Need to get a record count on a form

[Guest]

I have a button that launches a query that counts the records in a table. I
need to get that count over to the form. Is there a way, or a better road to
follow?

 

[Brendan Reynolds]

You may be able to get the result you're looking for with the DCount
function. Here's a link to the on-line documentation ...

http://msdn.microsoft.com/library/d...en-us/vbaac11/html/acfctDCount_HV05187157.asp

 

[Guest]

NewHeartMan, just use the bottom of the form (form footer) and have an
expression, something like =sum(fieldID), using of course the primary key of
the underlying table.

Destin
(e-mail address removed)