The code I posted will create a string that can be used as a Where clause for a query, but without the word WHERE. I would suggest a command button to run the query or queries you need. To call the function, you pass it the control object. strWhere = BuildWhere(Me.List1) Now, how you construct the query can be done a number of ways. You could do it all in VBA: strSQL = "SELECT

If you need to make multiple selections from your category list, you probably need a multi select list box rather than a combo box. It takes a bit more code, but will allow you to do this. To determine which categories the user has selected, you will need to use the ItemsSelected collection of the list box to find which are selected. Here is an example from one of my applications. It builds

As part of an ongoing effort to reduce the number of problems in the FreeBSD ports system, we periodically schedule removal of ports that have been judged to have outlived their usefulness. Often, this is due to a better alternative having become available and/or the cessation of development on the existing port. In some cases, ports are marked for removal because they fail to build and install