search query null results

[Matt Brown]

Is it possible to stop a query running if no results were found in the search.

I have a form with a query behind it which i use to filter data from a search form.

If the query returns no data on to the search results form then instead of showing a blank form can it either display a message or return back to the main form.

Any help would be appreciated...

thanks

Matt

 

[Rich]

Private Sub Form_Open(Cancel As Integer)
If (RecordsetClone.RecordCount = 0) Then
DoCmd.Close
Beep
MsgBox "There is no information for that period.", vbInformation, "No Info Recorded"
End If

 

[Matt Brown]

Thanks Rich,

Works just fine.

Matt