Test if query contains no records...

[Steff_DK]

I want to test if no records match the strSQL query.
How is that done??

I have:

strSQL = "SELECT bla bla...."
Form_frmnavnogby.RecordSource = strSQL
'HERE it goes wrong...
If Form_frmnavnogby.RecordSource = Empty Then
Msgbox "There where no matching records"
Form_frmnavnogby.RecordSource = AnotherstrSQL
...

 

[rubbernilly]

You can test that from any recordset.

The form has a recordset...

If Me.Form.Recordset.RecordCount >0 then
'records exist
else
'no records
End if

 

[deepthiv]

If you are using datareader u can test with

if dr.HasRows = false then
MsgBox("No rows returned")


--deepthi