>i am writing an application that uses sql selects to check the database, but if the select returns a blank recordset i get an error. i was trying to write code to check if the recordset is empty but cannot quite get it, can anyone give me a hand?
>cheers
>~M

Use the recordset's EOF property to detect an empty recordset.

if oRec.EOF then
   'empty recordset handler
end if