Filter combobox as you type - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Filter combobox as you type

Travis Hagen

3 years ago

Hi. I've watched Richards Filter Combo Box as you type video. Very helpful. Thanks Richard.

I have a question about multiple criteria in the where condition. If a Combo Box is based off a helper table and already has a criteria how do I add the search as you type to it. I can't seem to get it to work.

Original Rowsource = SELECT HelperID, HelperValue FROM HelperT WHERE HelperTypeID=8 ORDER BY HelperValue;

I'm trying to add this to the where condition: AND HelperValue Like ""*" & Category.Text & "*"" "

Thanks.

	Travis Hagen OP @Reply 3 years ago
Private Sub Category_Change() Category.RowSource = "SELECT HelperID, HelperValue " & _ "FROM HelperT " & _ "WHERE HelperID=8 AND HelperValue Like """ & Category.Text & """ " & _ "ORDER BY HelperValue; " Category.Dropdown End Sub

	Kevin Robertson @Reply 3 years ago
You are setting HelperID equal to 8 in your Where condition when it should be HelperTypeID. Also: Set Auto Expand to No (on the Data tab)

	Travis Hagen OP @Reply 3 years ago
I looked over that code 1000 times and didn't catch that. Seems to have done the trick. Thanks!

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View