sql text and visual basic

[Kori]

I have a part of code that calls a routine that sets up a sql text. If the data I am looking for is not in the database it crashes. Here is the line I open the data base with:

Set sn = g_cmwdb.OpenRecordset(sqltext, dbOpenSnapshot, dbReadOnly)

How do I know there isn't any data in the recordset I have initialized? Rather than getting a error called

'invalid procedure call or argument'

Help!!!!

 

[ITweedlie]

You can use the "On Error" function with resume next or end sub.