A multi-option box for a search form

I've created a database to search through all the different types of PTO used. I am using a continuous form where the search functions are on the top, the displayed data in the middle, and a pivot chart on that data below. Currently you can search by Employee Number, Employee name, data range, and one selected type of PTO. However, I would like to select multiple types and have it show up in the search. Here is a look at the code I am using:

Please Login or Register  to view this content.

I can get everything to work, however I can only select on type at a time. If I don't select any it displays all types.

Currently all data is within a master table called total time. And the items for the multi-list box are in a table calle pay code. Those tables are related based on PTO Type

If you know how to solve this problem, please help

CharterJP

CharterJP,

First off welcome to the website.

You need to edit your first post to be in accordance with the Forum Rules. ie. Wrap your code in Code Tags.

I have a couple of suggestions and questions.

What is PTO? (to me it means Power Take Off) (farming community)

I would suggest not using filters. I would alter the forms recordsource using SQL. It will give you the ability to create as complex of a filter as you could ever dream. And minimize how much data you actually have loaded.

I would make your complex search box a seperate form, use it and the selections to change the recordsource SQL statement for the main form.

Hope this helps,

Dan

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

CharterJP,

Here is a simpler example of what (I believe) you are trying to do:

Please Login or Register  to view this content.

This part here:

Please Login or Register  to view this content.

Looks up a field in a table I have that stores predetermined filters.

For example:

If I typed "Dan" in the Field Search on my form (an unbound text box) and I selected Suppliers from my unbound combo box on the form (Me.cboFilters) It would only show me the list of anywhere Dan is located AND ("Supplier = -1" is what is in the filter table) only those contacts who are suppliers.

Hope this makes sense,

Dan