Can you tell if a query returns a value or not? 1

[striker73]

As far as VBA, is there any way to tell whether or not a query returned a value or not? I have a form that applies filters to a query and then outputs a mailmerge Word document. When there isn't anything selected in the query, then Word opens and closes and that's it. I want to be able to tell my user that his/her search qualifications didn't return anything. Any ideas? Thanks!!!

 

[JoeMiller]

Something like this maybe?

[tt]
Dim NbrOfRecords

NbrOfRecords = DCount("*","MyQueryName&quot

If NbrOfRecords < 1 Then
MsgBox &quot;No Records!&quot;
Exit Sub
End If
[/tt]

HTH Joe Miller
joe.miller@flotech.net

 

[striker73]

That worked perfectly!!! Thanks!!!!