I have a question on combo box to select multi value in one field. For example, a book classified to more than one category (ie information, nutrient). Then I need to make a search box base on the inputs to find all the books under one specific category (ie information). Would appreciate to show me how to make it.

---

Reply from Richard Rost:

You can't select multiple items in a COMBO box. You would need to use a LIST box. Saving that information in your table isn't terribly difficult, but PARSING that data in VBA to create search criteria is. I cover it in my Access 321 class.