How can I ask if a Recordset has data?

[sysr]

How can I ask if a Recordset has data? (Also, should I be saying "populated"?)

10 sqlStringa = "SELECT OrganizationID FROM RegionalContracts WHERE Region=" & "'" & strSelectedRegion & "'"

20 Set ReportRS = Con.Execute (sqlStringa)

30 IF ReportRS(&quot;OrganizationID&quot <> &quot;&quot; THEN

Thank you!

 

[JerryDennison]

You might try this:

...
If ReportRS.EOF Then
...

 

[jhowley58]

The definitive method is:

if (ReportRS.BOF AND ReportRS.EOF) then.....

ie. the check is for nothing existing between BOF and EOF..

I use this exclusively to test for an empty recordset..#

JOhn.