Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2002
    Location
    Belgium
    Posts
    243

    Unanswered: Opening Form depending on subform

    I have 2 forms.
    The first one contains 3 continuous subforms :
    -subform_Red shows ID and description of all the possible gradations of the color red
    -subform_Green shows the same for all gradations of green
    -subform_Blue shows the same for all gradations of blue

    If I doubleclick one of the gradations I want a second form to open and show me the description of the doubleclicked colour in a textbox.

    I can retrieve either the ID and the description into each subform, but I can not get it done to open the second form with the description in a textbox.

    I was thinking of something like this:


    Code:
    public sub subForm_Red_Doubleclick()
     SecondForm_Form_Load(Me)
    end sub

    In the SecondForm-module :
    [code]
    public sub Form_Load (comingFrom as Form)
    Me.textbox = comingFrom.description
    end sub


    Any ideas ?

    Thanks

  2. #2
    Join Date
    Dec 2002
    Location
    Préverenges, Switzerland
    Posts
    3,740
    see if the attached suits.

    the A-wizard will do this for you when you add a button to your frmFirstOne + select open form frmSecondOne + select show specific record. you can copy the resulting code to the _DoubleClick event and delete the button.

    have the linking field (your ID field I guess) on both forms!

    izy

Posting Permissions

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