Unanswered: Taking value from 1 form to a 2nd form!
Ok Here is the exact scenario:
1. I have a form with 2 drop-down boxes which select their lists from a table (missionroster).
2. When you click on "Open Form" button a lookup form is brought up, but hidden and is used for referencing a couple of values on the original form.
The only problem I am having is that since I close the 1st form when you click the "Open Form" button, the value isn't carrying over to the lookup form. Any help on this? Thanks in advance!