I am trying to set up a filter on a form that works much like excel does. So, each column in my form would have a dropdown box that listed each unique value, and you could check the boxes for which ones you want, and uncheck boxes for records you don't want. Also, i would like this to be progressive, so it would use an and statement of sorts to continue filtering as you do the same to other columns. Basically exactly how excell does it when you turn on the filter sort.
I have 3 columns. first is COLOR second is SIZE and third is STYLE
if there are 5 unique colors listed in the color field, this filter would display those 5 colors and let me check or uncheck them. or have the blanks as well. Then I could go to size and check the smalls and XL's, then to style and you get the point.
I hope this is not an insanely hard thing to do. I would have thought Microsoft would have a built in thing to already to this, but I have not had any luck with macros.
Thanks in advance.