Pop Up Modal Form causes other pop up modal form to minimize

[patrickmcdiver]

I have a database that utilizes a log on form. Once username and password are entered correctly the form closes (no problem so far). On closing, the DB does a Dcount for any overdue project tasks and if there are any then my pop up, modal Task Reminder Form opens to advise that there are tasks due, If not, my Main Form opens (still no problem). As the Main Form opens, my DB does separate Dcount for any vehicle or equipment maintenance that is over due. If there is any, my pop up and modal Vehicle Maintenance Reminder Form opens. This happens almost simultaneously as the Task Reminder Form opens. However, the maintenance form causes the task form to minimize. I don't have code or anything telling the task form to minimize and can't figure out why it does instead of just being covered in the background. Also, the database looses focus and any other application open in the background becomes the focus.

Can anyone please explain what is happening and advise how I can correct it.

 

[JamesMcS]

Would it be possible to run both dcounts, storing the results in a table perhaps, then show the results or both in a larger form?

Or, you could run the dcounts, store in a table as above, then just make one form open after the other in your code.

As to why you're getting focus changes and minimizings, beats me! I've not used modal forms before, sorry...

 

[patrickmcdiver]

Thanks James. I'll try your suggestion

 

[Banana]

I believe the key lies in the modal + popup property.

Modal means it steals focus from other and insist that it have the focus exclusively until it closes.

Popup means it will open on top of the other forms. Obviously, you can't have more than one modal + popup form at a time.

If you disable either property, the behavior should then change and allow you to see the form while the other modal+popup form is open. Experiment and see what happens.

 

[JamesMcS]

That'll teach me not to read the post properly