Question:
I have form that has a command button on it, and when it’s clicked, it opens another form. I want to be able to set some values on the active form based on the values of the calling form. I can’t seem to find in the Help, or any other documentation, how to retrieve a value from an underlying form.
Answer:
For this type of application, I’d suggest creating a public subroutine on the form that does the actual showing of the form. This method lets you pass data into the form before it’s shown. Just call the Show method from within the subroutine when you’re ready to display the form.