"Geoffs" wrote in message
...
Hi Ennex,
Well assuming that you are using ADO to create the recordset from
your first
sql statement, then all you have to do is apply the "Filter" to get
a subset
from you first recordset.
EG: - oRS1.Filter = "[fieldname]=criteria"
'Then test for records returned
If (oRS1.BOF And oRS1.EOF) Then '--NO RECORDS

Geoffs,

Does an empty ADO recordset really display *both* BOF and EOF at the
same time?


Sincerely,

Chris O.