Help creating a specific type of form

[an amicable guy]

Basically I have a list in Excel that looks like this:

Item Category
a ---- x, y


b ---- x
c ---- x, y, z
d ---- z
e ---- x, z
. . .

I would like to create a form that has a combo box with each of the individual "categories" listed. So, for example if I selected "y" in the combo box, "Items" 'a' and 'c' would appear listed in a text box, and likewise if I selected "x" in the combo box, items 'a', 'b', 'c' and 'e' would show up.

I'm fairly new to Access. How might I go about doing this?

[NTC]

a combobox is fundamentally a query - and has one as its record source

make a continuous form for which the excel (as a linked table) is the record source.

put in the header of a continuous form; you can have a combobox of the 2nd column that returns all valid records in the body of the continuous form (and only display the value in the first column). The wizard will help you set it up and be sure to select the 'find record based on my selection'.

you can then have a second combobox of the 3rd column doing the exact same thing....

it wouldn't be feasible to have a single combobox that is sometimes looking at the second column and sometimes at the third.....

hopefully this helps get you going in the right direction......