[eduardo12]

Hi there, I need your help: I imitated another's database code to run a query to detect X situation while you open a form. If there are results a warning pops up.

So I made it a bit more complex, I've built three queries that detect three different situations on my database, all good so far. They work.

Now I need to developt the On Open Event Procedure so that the three queries run independently, and, if results for any of them, the pop up messages appear.

What I accomplished works ONLY if there are results for ALL OF THE QUERIES. But if there are no results for the first one, the other queries are not checked.

I hope I'm clear, I need to make the "on open" code independent for every query.

I hope I was clear

Thanks!

[OBP]

You should not be using the Exit Sub within the first 2 If/Then statements as if it doesn't meet the requirement the code just stops and doesn't check the do the other tests, you can use
Exit If
if you want.

[Rollin_Again]

I would put the query itself in it's own procedure and then call it from another subroutine. Then all you have to do is use a loop to call the procedure three times passing it the appropriate arguments each time.

Rollin

[eduardo12]

I don't have the skills to do it more sophisticated than this, but OBP's suggestion worked; now all queries are checked despite their individual results.

Thank you guys!