Suspend Processing during Form Display

echovue · November 16th, 2004, 02:18 PM

I am using VBA to open a second/child form from the parent form, and would like to be able to suspend processing in the parent form, until the child form is closed. Does anyone know if this is possible, and if so, how it can be done?

DoCmd.OpenForm "frm_Child"
[Wait until Child closes]
strVariable = strAnotherVariable

Thanks

Mike
EchoVue.com

Ray Pinnegar · November 17th, 2004, 07:24 AM

Add the 'Dialogue' parameter to the open form statement for the subform.

Cheers Ray

echovue · November 17th, 2004, 11:09 AM

So many options - So little time!!

Thanks for helping narrow it down.

Mike

Mike
EchoVue.com