Making code wait/pause until event

[faythe1215]

I have a form with a button that opens up a pop up form. Once the user enters the necessary information in the pop up, it's set to close.



I'd like to be able to come back to the original form and continue executing code once the pop up closes.

    DoCmd.OpenForm "frmItemAdd"
    Forms!frmItemAdd.SetFocus
    DoCmd.GoToRecord , , acNewRec
    Forms!frmItemAdd.AllowEdits = True
    
    ' This code kind of just needs to just sit here and wait until "frmItemAdd" closes.
    
    ' I have more code I'd like to execute here

[A S MANN]

add a button "close" to frmItemAdd form and add on click event
Docmd.Close "frmItemAdd"
DoCmd.OpenForm "original form"

[rpeare]

You will likely have to add a timer that checks to see if your pop up form is still open every few seconds then when it's no longer open continue with your code. Or follow this advice:

http://bytes.com/topic/access/answer...il-form-closes and set the secondary form to DIALOG which will force the code to wait (at least from what I've read)

[faythe1215]

All right, related problem.

The information entered into the second form (now dialog box) should, once it's closed, be accessible by the first form. It is not. I have tried Me.Refresh, and had no luck. I have also tried to DoCmd.Requery and not only does it take me back to the first record (which I'm sure I could change with a bit more coding) but it also does not actually refresh the information the way I described anyway.

Wait... The field I am trying to refresh belongs to a subform. *Sorry, I know that I'm actually thinking out loud now*

Is there a way to requery or refresh that form/field on the subform from my main form? - Never mind -

You guys can go ahead and set this to solved while I kick myself for my n00bs.