Hi. I have a search page which lists 10 different checkboxes which represent services for clients. I am trying to return a recordset which will tell me which clients have each service checked off. The problem is wildcard '%' does not work for checkboxes. So I tried to have the default for each checkbox to equal FALSE . However, when I try to run a query on multiple checkboxes it doesn't return the right data.

For example , say accounting , billing and bookkeeping are all services. I run a search and click accounting. The recordset returned will give me the clients with accounting = true, but where the other two = false. What I need is a wildcard that will work for the checkbox so it will give me all instances.

Thanks for your help

not really, but finding all the recoirds that have accounts ticked then, you are already sellecting all the other combinations fotr the other two options. yes?