Results 1 to 5 of 5
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    St. Marys, Ontario, Canada
    Posts
    270
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Cascading combo boxes (2002)

    Thanks to all who helped me master cascading combo boxes. Between getting the flu and making sure every letter and symbol was correct, it took me a long time, but I now know how to do it. Now on the the next phase. Can I have the first combo box show one subform based on the value and another subform based on another value. For example, you might have a field in the first combo box titled type of form. The values might be: registration, unemployment, taxation, etc. What I would like to see is a subform based on the values in a table for each type of form, but a separate subform based on which form is chosen. Is this possible? Is it difficult?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Cascading combo boxes (2002)

    Sorry, you've lost me. Could you try to explain that more slowly?

  3. #3
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    St. Marys, Ontario, Canada
    Posts
    270
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Cascading combo boxes (2002)

    <img src=/S/compute.gif border=0 alt=compute width=40 height=20> Ok, I will type it out at half speed. Let's say I had different forms that I want to appear on the record of my employees. They are: application form, tax form, and insurance form. Each form will have its data stored in a separate table (although different parts of the same table could work, too).

    I want to create a combo box to select the form title field, thus, showing: Application form, tax form, and insurance form. When I select one of them, the proper subform created from its table will appear or on a tabbed form. When I select another, the other subform will appear that matches the type of form selected. Thus, I will have 3 tabs in the subform, but the information will only appear on the proper tab when the type of form is selected in the combo box.

    I hope that explains it better.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Cascading combo boxes (2002)

    You could put the three subforms on top of each other, and set the Visible property of all three to No.
    In the After Update event of the combo box, set the Visible property of the appropriate subform to Yes, and that of the other two to No.

    Or use a tab control (your description seems to suggest that you have that, but I'm not sure I understand) with three tab pages, and one subform in each of the tab pages.
    In the After Update event of the combo box, set the Visible property of the appropriate tab page to Yes, and that of the other two to No.

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Cascading combo boxes (2002)

    Cf the very similar replies (to very similar questions) <post:=666,014>post 666,014</post:> <post:=665,342>post 665,342</post:>.

Posting Permissions

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