Results 1 to 5 of 5
  1. #1
    Join Date
    Nov 2013
    Posts
    2

    Unanswered: Help creating a very specific type of form with combo box

    Basically what I have is a two-column table from Excel, looking roughly like this:

    a ------- x, y
    b ------- x, z
    c ------- x, y, z
    d ------- y, z
    e ------- y
    f ------- z
    etc.

    Wherein each of the variables in the right column represents a "tag" for the item in the left column.

    I would like to create a combo box with, in this case, the three "tags": x, y and z. When the tag is selected in the combo box, a separate list box in the form shows all of the items from the left column that contain that tag.

    So, for example, if someone selected "y" in the combo box, then "a", "c", "d" and "e" would all show up in the list box.

    Is this kind of form feasible in Access? I'm fairly new to the program.

  2. #2
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    You're basically talking about cascading combos:

    Cascading Combos

    but in your case you'd have to use Like and wild cards or InStr() to identify records that contained the selected value.
    Paul

  3. #3
    Join Date
    Nov 2013
    Posts
    2
    Thanks. That actually did the trick.

    Just one further question:

    Say I had a third column consisting of the numbers 1-4, with each item in the first row corresponding to one of those numbers. i.e.:

    a ------- x, y ------- 1
    b ------- x, z ------- 1
    c ------- x, y, z ------- 3
    d ------- y, z ------- 2
    e ------- y ------- 4
    f ------- z ------- 1

    On my form I'd like to have the corresponding number displayed in a box whenever the letter in the first column is selected from a list box. Short of creating a separate query for each entry in the first column, is this possible?

  4. #4
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    no
    if there is a third level, the use a third combo box. hence why its called cascading combo boxes, once you've got past 1 linked combo the rest is all the....
    I'd rather be riding on the Tiger 800 or the Norton

  5. #5
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    Is this what you want?

    Autofill
    Paul

Posting Permissions

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