I'm revamping a database I created several years ago at work. One of its functions is to detect common typos in data entry. As such I have a number of queries that look for them. Generally, the data is good and closing a bazillion empty queries was time consuming and annoying. So I made reports out of them which have an option to not open if it's blank, Cancel = True. I loaded all of these in a macro and it worked.

With the new version I'd like to have the reports in VBA instead of a macro. However, VBA isn't liking the whole, open it but not if it's empty thing and is giving me an error "The OpenReport action was canceled."

Do I have to go back to a macro or is there a way around this? I like using the reports because I can use the header for a short description of what the query was looking for.

TIA,
Monica