I've looked all throughout the documentation, but I can't find an answer to this seemingly simple question.
I want to write a function much like the DCount domain aggregate function that will allow me to count the number of records in a query that meet a specific criteria. I want to use this function in several different reports that are tied to parameter-based queries. My questions is:
Is there some statement that allows me to access the Recordset that the underlying query produces that is used in the report? I'm hoping that there is some simple way to do something like this:
DIM thisDB As Database
Dim thisRS As Recordset
Set thisDB = currentDB
Set thisRS = thisDB.currentRS
I'm fairly new to this so I'm hoping that this isn't a stupid question. Any help would be appreciated