Count of Records in Query

[McArthurGDM]

I need to run a count of the number of records in a Query within my VBA code. Basically,



if the count of the number of records within a query is 0, then the code runs and if not, the code breaks and the user is left with an error message.

Problem is, I don't know how to reference the count of a query within VBA.

Any suggestions?

[amrut]

You can use DCount function See her for it's usage. http://www.techonthenet.com/access/f...ain/dcount.php
Use your query name for domain.

[McArthurGDM]

Thank you! I'll give it a shot and see what happens, but it looks like my solution.