Form opens in background

[David]

I am opening a form via a command button on another form.
But the second form opens 'behind' the first and cannot be
reached. My workaround is to close the first form before
opening the second, but that means I cannot return to the
first form after closing the second - which is not what I
want. Why is my second window not opening in front of the
first?

 

[John Parkinson]

David,

I am not 100% sure this is the correct solution.

You may have to set the MODAL property on your second
form. This will force the second form to have control,
which would return to the first form upon closing.

Hope this helps!

John

 

[Charlie]

In the marco for the command button on the first form,
enter in the action column the "close" command and
reference the first form in the action box at the bottom
of the macro form.

Create a new macro (Return) and set the macro to open the
first form.

In the forms that are referenced by the first form go to
properties and on the event tab choose "On close" and
enter the "Return" macro.

Now the first form will close when the second is open and
the first form will open when the second or third form is
closed.