MsgBox when ApplyFilter doesn't return any records

H

Hermanson

I want to run a macro that applies a filter to a form (ApplyFilter).
The condition is a typical expression, but can return null records.
I've done this, but what if there are no records returned?

How can I show a messagebox stating that no records where filtered because the
condition was not met?

Like this:
ApplyFilter with condition
If condition is met, show the form, and stop macro

If condition is NOT met, show message, close the form, stop macro



Any help will be greatly appreciated.
 

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

Top