Hi all. The folks at my current project are obsessed with creating
customized filters. I tried showing and telling them about Filter By
Selection and Filter By Form which will probably outdo any
functionality of what we customize but no luck. It's a bit annoying
on one hand but at the same time keeps me busy - can't complain.
The first, more simple task is to select one of about 8 sales reps,
select a filter of >=1000 on one column and >0% on another, all
applied at once. I'm not sure how the code would look or what
approach to take. Some of my experimenting didn't allow me to select
all three at once - it was one or the other.
The second issue is - is this really the way to go. I'm sure once
some of the main concepts are down, customizing text boxes and option
groups are a breeze. Are there certain commands which are commonly
used? Is there programming in which I can replicate the functionality
of Filter By Selection and Filter By Form which I could make more user
friendly and place in the header of the form.
Alot of the resources I have been using seem to assume you would use
the pre-made filter commands. fun, fun, fun.
Jeff