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.
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.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 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?




Reply With Quote