Returning query result in code

  • Thread starter Thread starter Guest
  • Start date Start date
Charles Tam said:
How do I return the query result in a function to a module code
caller?
Click to expand...

If the query returns multiple records, you open a recordset on the
query. If there is only one value you are interested in, and it's a
stored query you are talking about, you can use DLookup to get it,
specifying the query name as the domain argument.
 
Back
Top