Popping up a form with focus

[sodakotahusker]

I need to interrupt my users (they really want this) to inform them when they have a new contract to process. I have a scheduled task which runs every 3 minutes to determine if any data has arrived indicating a new contract. If data has arrived, my application displays a grid displaying that information. I need to make sure this screen pops up over what they are doing so they see it. How can I do this (I'm guessing I'll have to use a Windows API?).

 

[bjd4jc]

I am not sure if the ZOrder method of the form would display over everything but you can try that.

Do a search on this Forum For SetWindowPos or see thread222-470179

 

[HaroldGE]

If you are displaying this message in an Access Form then set

Form Property PopUp (under Other) to Yes
-and-
Form Property Modal (under Other) to Yes

The Form takes over and nothing can be done until it is closed.