Reverse the Dropdown - Filter Combo Box Data in Microsoft Access


	Back to Filter Combo Comments List

Upload Images @Reply Bookmark Link Email

Reverse the Dropdown

Tom Mura

12 months ago

Love this feature but after I select the item in the dropdown the combo box drops down again and I have to click away or tab. Is there a solution to this so that the dropdown "rolls up" after I select an item?

	Kevin Robertson @Reply 12 months ago
Give this a go (see screenshot below).

	Kevin Robertson @Reply 12 months ago

	Tom Mura OP @Reply 12 months ago
Perfect! Thank you!

	Tom Mura OP @Reply 12 months ago
Oops, one issue. This solution closes the dropdown as soon as any character is typed rather than just when an option is selected. That doesn't allow the user to see the list being filtered as they type. Can we put the 'allowDropdowns = False' in another event to close it after the selection?

	Tom Mura OP @Reply 12 months ago
This code is already in the AfterUpdate Event if it makes a difference: Private Sub PlayerSearchFilter_AfterUpdate() Me.Filter = "LF=""" & PlayerSearchFilter & """" Me.FilterOn = True Me.PlayerSearchFilter.RowSource = "" Me.PlayerSearchFilter = "" End Sub

	Kevin Robertson @Reply 12 months ago
Did you include everything I show in my screenshot? It works perfectly for me.

	Tom Mura OP @Reply 12 months ago
Yes, my guess is that the filter I have running in the AfterUpdate Event is conflicting with the allowDropdown = False line of code.

	Tom Mura OP @Reply 12 months ago
I got it! Thanks for your help.

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