Results 1 to 4 of 4
  1. #1
    Join Date
    Apr 2003
    Location
    Manchester, NH
    Posts
    57

    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!

    Dalynch

  2. #2
    Join Date
    Jan 2003
    Location
    Rockville, MD
    Posts
    179
    Make the "Open Form" button just open the new form, but not close the old form.

    In the open event of the new form, get the values you need from the old form, then close the old from from there.

  3. #3
    Join Date
    Apr 2003
    Location
    Manchester, NH
    Posts
    57
    And there in lies the problem! I need to close the first form, because on the unload event of the form I open a third form...What a tangled web I weave!

    Dalynch

  4. #4
    Join Date
    Jan 2003
    Location
    Rockville, MD
    Posts
    179
    Won't the third form still open, if you close the first form from the second form?

    Tangled indeed!!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •