Trapping nothing found on ApplyFilter ?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When I execute DoCmd.ApplyFilter, is there any way I can trap the 'nothing
found' condition and put out a message box before the screen is updated?
 
After applying the filter, test the RecordCount of the RecordsetClone of the
form:

DoCmd.ApplyFilter
If Me.RecordsetClone.RecordCount = 0 Then
MsgBox "None found"
End If
 
Ok I though you received a message saying nothing is found.

Glad you found a solution by your-self then : - )

Yanick
 
Back
Top