Consulting

Results 1 to 5 of 5

Thread: combobox generate another combobox

  1. #1
    VBAX Mentor
    Joined
    Dec 2009
    Posts
    416
    Location

    combobox generate another combobox

    good morning

    I would like to know if it is possible to create an combobox based on selection from another combobox. example: I have one combo(1) and wen I choose something from that combo to generate another combo(2) that was not existing and so one combo(2) to generate combo(3) till 5.

    can someone help me with an example.
    many thanks

  2. #2
    VBAX Guru
    Joined
    Mar 2005
    Posts
    3,296
    Location
    Yes, it is quite common to do something similar to this, although it is not normal to "create" the combos at runtime.
    You would normally create all the combos at design time.
    The way to base one combo on the Selection of another combo is to filter the SQL Row Source of the second combo with the first combo using the
    forms![formname]![comboname]
    where formname is the name of the form and comboname is the first combo's name.

  3. #3

  4. #4
    VBAX Mentor
    Joined
    Dec 2009
    Posts
    416
    Location
    thx. OBP..but, I saw that I putted in the wrong forum. Can some one from administrators to move this, to the excel forum. thank you

  5. #5
    VBAX Mentor
    Joined
    Dec 2009
    Posts
    416
    Location
    ok ..I putted this thread to excel ..please, one of the admin delete this thread. thank you

Posting Permissions

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