Show the Form that's going to "Do its Thing", Modaly, that way Processing within the Calling Form won't continue until the Modal Form is Unloaded or Hidden, ie.
Code:
Private Sub Command1_Click()
    'Do Some Stuff
    'Let the Other Form "Do its Thing"
    Form2.Show vbModal
    'Do the Rest of the Stuff Here After the
    'Other Form is Hidden/Unloaded
End Sub
------------------
Aaron Young
Analyst Programmer
[email protected]
[email protected]