Form as a temporary modal

[Guest]

I have a comand button on a form to open another form. When this command
button is used to open the second form, I want it to open as modal. However,
When I call
DoCmd.OpenForm stDocName, , , , , acDialog, stOpenArgs

It opens modal, and must be closed before switching back to the parent, but
the user can not scroll through the form, (it's a large, complex form with
sub forms).
As I understand it, acDialog sets the modal and popup form properties to
true. How do I leave the popup = false using the OpenForm method? Or is
there another way to do this?

I just don't wan't users to switch back to the original form without closing
it first. I've been using the Open args property to link forms, but that
doesn't work if the form being called by the docmd.Openform method is already
open.

Any help would be appreciated.

Scott Collins

 

[Marshall Barton]

I have a comand button on a form to open another form. When this command
button is used to open the second form, I want it to open as modal. However,
When I call
DoCmd.OpenForm stDocName, , , , , acDialog, stOpenArgs

It opens modal, and must be closed before switching back to the parent, but
the user can not scroll through the form, (it's a large, complex form with
sub forms).
As I understand it, acDialog sets the modal and popup form properties to
true. How do I leave the popup = false using the OpenForm method? Or is
there another way to do this?

I just don't wan't users to switch back to the original form without closing
it first. I've been using the Open args property to link forms, but that
doesn't work if the form being called by the docmd.Openform method is already
open.

I don't know what the problem with scrolling could be. I
would not expect that to be troublesome.

An alternative to using acDialog might be to add a code
character to the front of the OpenArgs string so that the
form can set it's own modal property in its Open or Load
event??