All of my forms are MDI children. I have one form that is collecting input parameters for a report. One of the parameters needs to come from another form. For the life of me, I can't get it to work.
Code:
        If Trim(Vendor) = "Y" Then
        Else
            '------------must select a vendor
            glbPart = "GetAVendor"
            frmVendorList.Show()
            '-- we now have something in glbvendor
            MsgBox(glbVendor)
        End If
I have to message box code just to verify the selection. glbPart is just a hand off parameter to tell the frmVendorList code to come back to this form rather than where it was origianlly programmed to go.

I tried a do until glbVendor <> "", but that put me into a death loop and I never got to select a vendor from the vendor list form. Obviously, the easiest would be if I could make frmVendorList Modal, but I can't see how to do that once it's been created modally.

Any ideas?