Determining number of records in recordset

[EddyLLC]

I use the following code to produce a recordset of a query(stDocName). Is there a means to determing the number of records in the produced recordset? Thanks

Set qdf = DB.QueryDefs(stDocName)
Set prm = qdf.Parameters(0)
prm = strFileRef
Set rs = qdf.OpenRecordset

 

[RoyVidar]

[tt]msgbox rs.recordcount[/tt]

You might throw in an rs.movelast first, though, to fully populate the recordset first (and check for .bof/.eof or similar first)

Roy-Vidar