visible form but not have focus when true

[Ruegen]

Is there a way to have a form become visible but do so in the background?

currently I load a pop up form if a recordset changes count and sets the visibility of the form to true - false if the user closes the popup

the problem with forms("fromName").visible = true is that the form becomes the focus - I just want to have it become visible in the background so the user doesn't lose focus on the current form they have in front of them

any suggestion?

[June7]

What happens if the top form is opened as Modal?

[Ruegen]

What happens if the top form is opened as Modal?

I only have one form open as modal and it's the one form where the popup form is asked not to become visible so it doesn't affect the top form.

[June7]

I just did a test. Opened a form as popup and modal. Then programmatically opened another form. Second form stays behind popup. Set second form as not visible then visible and popup keeps focus. Has to be both popup and modal.

[Ruegen]

I just did a test. Opened a form as popup and modal. Then programmatically opened another form. Second form stays behind popup. Set second form as not visible then visible and popup keeps focus. Has to be both popup and modal.

Just to be clear - it's the popup form I want in the background. It is what becomes visible/invisible but without taking focus from whatever the form a user has in front of them...

I thought modal locks it to priority so they can't move to another form.

[June7]

'Popup' forms by nature must open on top of already open forms.

Modal means can't click to other form but focus seems to go to nevernever land when another form is programmatically manipulated.

Do some testing. What do you experience?