Well you could use the DCount Function. You would have to select a field in the query that didn't have nulls, like the Primary Key, and then use this as the ControlSource for the textbox on your form:
=DCount("[FieldNameHere]","[QueryNameHere])
That should do it.
Paul
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.