I need a list/drop list, but I haven't been able to find the answer.
say in my first column, it goes down 100 rows, and in those rows are numbers 1-10 randomly. I need to make drop down list(?) at the top of the column that I can select any of those 1-10 numbers, and by doing so, will bring up only the rows that have the selected number.

Say I click the drop list, and click number 5. Then, only the rows that have the number 5 are show, until I click on the drop list again, and pick another number (we will say 3), and then only the rows with the number 3 are shown.


Ideas?

* 2 hours ago
* - 3 days left to answer.

Additional Details

2 hours ago
Also, if in the list, nothing is selected, then all the row, regardless of what is in them, shows up.

I think you would have MUCH better luck doing this in Access