filters question

[Guest]

is it possible to filter the contents of a listbox, based on the value of the
listbox?

i.e. there is a listbox of cateogrys, and one is selected, then a command
button is clicked and it all filters according to that selection

if this is possible, please help

 

[Rick B]

Well, If you filter it based on that selection, then you would only have one
item in it.

Commonly,you would have TWO listboxes. The first would be categories, and
the second would be products. You could code it so that if you select a
particular category in the first box, the second box would only show
products with that particular category.

 

[Guest]

the listbox has 2 columns and one is categorys and one is products, so there
can be more than one item with the same category... is it possible to filter
within the list box, or should i still use two? in which case, how would i
code that to work in either case?

thanks for your help in advance

 

[Guest]

There is a sample database that does just this @
http://www.microsoft.com/downloads/...A1-3C4E-4371-81E4-F9347B7A1DD7&displaylang=en