Thanks everyone for your input.
Finally found the solution I was looking for.
Unfortunately, it requires an API call for Sleep to work, but otherwise, it does what I originally wanted.
Revised code below:
Private Sub cmdReplace_Click()
Dim newForm As [Form_Form Question]...