extra-form communication problem

[WoundEdGoat]

Don't mean to be a pest, but I need help again.

Okay, I have this form that I want to call on this other form, get a small bit of information, and execute the result of the information.

What I want to know is how to stop the execution of the sub that I called the second form from and wait until I get the infor from the other form before executing the rest of the sub... I hope you can understand all that.

 

[Foada]

Start a new project and add a command button to the form. Then add this code to the form


Private Sub Command1_Click()
Form2.Show vbModal
'vbModal Halts the execution of code here
MsgBox "Back to Form 1"
End Sub

Now add another form to the project and add this code to the second form

Private Sub Form_Load()
MsgBox "Form 2"
End Sub


Hope this helps If you choose to battle wits with the witless be prepared to lose.

 

[WoundEdGoat]

Ah yes... I seem to have forgotten about the vbmodal command... Thatnk you very much.