Form in foreground question

[GregSmith]

I have a main form opened up and when I select a command button - it opens up a second form on top of the main form.

I want the second form to stay on top unless you select the close command button on the second form. If you click out of the second form - it stays in the foreground. They only way to clear it is via the close command button.

Any ideas on how to do this?

I have tried to play around with the event deactivate - but does not work the way I need.

 

[Calvin]

In design mode, set the second forms POPUP property to yes/true and it will always be ontop even though you've gone back and given the main form the focus.

 

[GregSmith]

That worked. Only thing is - even though the second form stays on top, you can still click on items on the main form.

Is there a way to make the main form inactive without closing it allowing you to only click on the second form?

 

[Rich]

Set the Forms Modal property to yes

 

[GregSmith]

That did it. For as long as I have been playing with access - I have always wondered what popup and model did.

Now I know... Thanks for the help!!

 

[Mile-O]

For as long as I have been playing with access - I have always wondered what popup and model did.

Does your F1 key not work?

 

[GregSmith]

It used to work great till the anti virus nazi installed McAfee on my laptop.
Now when I go into help - it just sits there and I listen to my fan kick into high gear. Bad thing is - I disable it and at midnight, the epolicy server re-enables it...

Long live the IT nazi!