Adding options to a filter

[jerry23]

Hi guys. I'm working on a payroll form that lets people right click on a field, like name, and filter all records for those with a particular name on it. When they right click, they have the option to type in what they want to filter for( filter for_____) Is there any way to make that "filter for" field into a combo box that queries a table for values.

 

[JPeters]

Sure,

Setup a combobox add all of your choices...
Now in the after update box of your combo box do this.

Dim strCmb as String
Set strCmb = comboBox ' this sets the string equal to whatever text is in that combo box

If ComboBox = "No Filter" Then ' make an option for no filter as the first (default) value
Exit Sub
Else
Filter For strCmb '? <---(change) run your filter for and type strCmb as the filter - I'm not sure what the command line is
End If

Make sense?

-Josh ------------------
-JPeters
Got a helpful tip for Access Users? Check out and contribute to 'How to Keep Your Databases from becoming Overwhelming!'
thread181-293590
jpeters@guidemail.com
------------------

 

[WildHare]

Jerry, I have a sample DB up on my website that shows a continuous form, and performs FILTERING based on any field-content click, and sorting based on any field-LABEL clicks. It's a very simple technique, it might give you some ideas as well.

Here it is:

http://www.jmhare.com/databases/filtersort.zip

Jim Me? Ambivalent? Well, yes and no....
Another free Access forum:

http://www.forumco.com/jmhare

More Access stuff at

http://www.jmhare.com/wildhare2.htm

 

[jerry23]

Awesome...

Thanks jpeters, jim... helped a lot.