Question Regarding regaining control in code after calling a form 1

[Paul7905]

I have a form on which an event is coded for a control on the form.

One thing I do in this event is open another Form on which the user can view some data etc.

What I would like to do is, once the user has completed their use of the form opened from the code, is to pass control back to the line of code following the open of the new form so I can check some flags to potentially invoke an action or not.

Usually in code when I open a form I close the currently active form after opening the new one ~ So, I have no experience how to handle leaving the active form open, calling another form and then resuming code after the called form is closed.

Can someone help with a technique to accomplish this ?(maybe this belongs in the VBA code portion of the site)

Thanks !

Paul

 

[bcomtom]

Paul,
You must open the second form, the form you open in code, in dialog mode. For example,


me.visible = false
DoCmd.OpenForm FormName:="jc 0220 allocation_package add", _
View:=acNormal, _
DataMode:=acFormPropertySettings, _
WindowMode:=acDialog
me.visible=true

The focus will remain on the second form until it is closed, then the next line of code in the calling procedure will execute. Prior to invoking the second form I usually turn off the visible property of the calling form then immediately turn it back on when control returns to the procedure. Be aware that you will not be able to access the calling form while the called form, opened in dialog mode, is open even if it is still visible. Also, check the documentation for the two types of dialog mode: modal and application, I believe.

Also, if you want values from the called form then it must be closed from the calling form after it has retrieved the values. But I think this is beyond the scope of your question.

Tom Morris

 

[Paul7905]

thanks so much ~ that worked great !

 

[chdavisjr]

Good morning ... Tom, in your last response on Oct 31, 2000, you said:

Also, if you want values from the called form then it must be closed from the calling form after it has retrieved the values. But I think this is beyond the scope of your question.

Tom Morris

This is exactly what I need ... I am going "crazy" here trying to do this. Would you mind telling me how to accomplish this? Or, rather, tell us all!!
Thank you so much in advance!
Chalmers H. Davis, Jr.