Pop Message in form based on query results

[CatManDo]

G'Day:

I have tried numerous things to try and create a pop up message or form to alert users of a timing conflict in a scheduling program.
I am not real familiar with codes and am not sure how to handle this.

I used Jason Browne's web site to help me construct a query that will list a result of time conflicts (ie some project is scheduled to occur before another one is completed).
What I need to have happen is the alert message or form opens when this conflict occurs but does nothing when the timing is ok.

I am not very familiar with code and am having a road block mentally. All help is appreciated!

THANKS

 

[carash77ash]

what code do you have currently

ash

 

[CatManDo]

Well - I have done away with everything that I had because I couldn't get it to work.

I tried to create an openform command that would open if the query came back as Null - but it didn't matter which way it went - I got the pop up form.

I know that isn't helpful - I am sorry - but I got so frustrated I shot it :-(.

 

[carash77ash]

This can be done. It would take alot to explain. You need to use code "isnull" command. Without object names or what triigers the code i can't really offer code suggestions.

Ash