title: How to freeze Parent Form while Child Form is open
body: <p>I have a situation where, in certain circumstances, i need to open another form and keep that form focused (modal = true) and when they are dont and it closes, a control on the parent form is refreshed with possible data that might have changed.</p>
  <p>Originally i had a method that would <code>DoEvents</code> while the child form was open but it cause several of the child forms to be unusable (they werent databound at the form level) for data-entry/edits.</p>
  <h2>ShowForm Method - Originally</h2>
  <pre><code>Public Sub ShowForm(par As Form, nm As String, _
                      Optional whr As String = &quot;&quot;, _
                      Optional args As String = &quot;&quot;, _
                      Optional mode As AcFormOpenDataMode = acFormPropertySettings)
      DoCmd.OpenForm nm, acNormal, , whr, mode, , args
      
      While IsOpen(nm)
          DoEvents
      Wend
  End Sub
  </code></pre>
  <p>In order for me to get the Child Forms to be usable consistently, i had to comment out the <code>While...Wend</code> loop.</p>
  <p>Is there another logic pattern i could use either inside this method or the OnClick of the calling control, so that way when they close the Child Form i could have code execute after the closing of the childform?</p>