If statement execution

[swykpisz]

What would the code be if I wanted to execute a condition if a query was null? I have something like
If "qryData" = Null Then
Msgbox "No Data"
Else
Msgbox "There is Data"
End if

The part I'm confused at is what command do I use to check if query qryData is Null?

 

[ZmrAbdulla]

Try Dcount Function

If DCount("AfieldName", "QueryName") = 0 Then
    MsgBox "No"
Else
    MsgBox "Yes"
End If

Zameer Abdulla
Visit Me (New Look & style)