receive returned value from doCmd.openquery

V

Van T. Dinh

OpenQuery Method simply opens the DatasheetView of your
Query.

If you want to "receive" the Count in code, you can use
the DCount() function. BTW, you can use DCount() directly
on the Table and therefore, you don't need the Query,
either. Something like:

DCount("*", "t1", "[CustID] = 123")

(assuming [CustID] in numeric)

Alternatively, you can create a Recordset and then get the
RecordCount of the Recordset. This requires a few more
lines of code so I prefer to use DCount().

Check Access VB Help on the DCount() function.

HTH
Van T. Dinh
MVP (Access)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Selecting next record in dynaset and assigning to variable 1
Curiosity question relating to Dcount in a Text Box and in VBA 5
recordCount of Recordset returns 1, but is wrong 3
Use Input Box Value as Creteria 4
Problem with Filters 6
Run-time error '3045' 6
Do While... Looping through records on a form or RecordsetClone 0
DCount Syntax 2

Top