Pop Up Form Question

[CatManDo]

G'Day
I am working on a form that will be utilized to enter participants and their times into a database.
I searched the forum and saw a way to create a query to "notify" of a conflict - so far all works.
I have a subform based on this query attached to my form. What I would like to do is to have a pop up form when the "conflict" is present.
I have been thinking about it - but am not real sure how to proceed. I did use the cmd.openform, but was not getting it to open correctly. I guess I need some kind of a command to make it open only when the subform query is populated - but I am not sure where to go.

Ablige

 

[supercharge]

What does the subform do, alert when there's a "conflict"? What do you mean by "conflict"? Duplicate?

If all the query does is to "notify" of a "conflict", why need a subform to base on it?

 

[CatManDo]

Well - -

The query/subform notifies me of a conflict visually. The conflict would be anything that a participant has during the same time (ie John Doe can't have two things scheduled at the same time).

I guess the reason I put it in the subform is because I am not real sure how to make the dBase visually warn the operator that there is a conflict. (my Access skills aren't that in depth).

If there are other /better suggestions I am definately open for them.

Thanks

 

[supercharge]

Oh, that can be done easily with a simple DLookup. I'm about to leave now; I'lll get back to you tomorrow if no one else has helped you. In the mean time, you can play with the function. So "conflict" means duplicate. I got cha!

 

[supercharge]

Sample

See attached, a simple sample created just for you. It uses DLookup and Msgbox to display the message.