Access 97
I want to maintain one list referenced by several combo boxes. Instead of the users having to look through a list of 40 items, I want to filter it based on the field they are in. For example, if they are in the field called CHAIR, I want the combo box to only show the 14 chairs in the list.
I have modified my list table to include a "category" field in the hopes that I can have code that says to only display the "description" field for those records where the "category = Chair".
Any help would be greatly appreciated!!!
I want to maintain one list referenced by several combo boxes. Instead of the users having to look through a list of 40 items, I want to filter it based on the field they are in. For example, if they are in the field called CHAIR, I want the combo box to only show the 14 chairs in the list.
I have modified my list table to include a "category" field in the hopes that I can have code that says to only display the "description" field for those records where the "category = Chair".
Any help would be greatly appreciated!!!