Filtering using Combo Box

J

Jim Kennedy

Try something like this in the after_update event of your
combobox:

Me.Filter = "YourField ='" & Me.ComboBox & "'"
Me.FilterOn = True

Please note that the single quotation marks are not used
if this is a number field.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using a Combo Box for Filtering a Continous Form 2
Filtering and Removing Filter based on a combo box 3
Creating a Search using a combo box and then creating a report. 4
Trouble filtering the values of a combo box 2
Filter a Continuous Form using a Drop-Down Box 8
Combo box 0
Combo Box to select a record and populate fields in a form 5
Filtered field goes blank 2

Top