Trapping nothing found on ApplyFilter ?

M

mscertified

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?
 
A

Allen Browne

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
 
Y

Yanick

Ok I though you received a message saying nothing is found.

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

Yanick
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Docmd.Applyfilter 1
Trying to ApplyFilter to form 3
Error message: "Word found unreadable content in FILENAME. Do you want to recover the contents of this document? 0
ApplyFilter gives error only when subform is placed on main form 1
Docmd applyfilter 0
ApplyFilter question 1
Access 2007 Open forms with FilterOn and form fails to open 5
Slow when "Mark all as read" 3

Top