I want to have a listbox on my switchboard (lstFilter) filter by the fields [Reprint Edition] which can contain GET, DNG, or UNC three letter codes and/or [Reviewed Item] which contains only the codes INC or EXC. (I.e. I would like someone to be able to select that they want both GET and EXC or GET and INC, I would also like there to be a function for <All> that applys no filter to the query) Right now, the code is working well to export the imported table, but I was hoping some SQL and Access experts could help me take it to the next step.

I can't seem to get it working mvasilevsky, even with the edit. Thus far I've copied and pasted your code into the VB portion of my form_switchboard and renamed query Q to Export_EndNote as well as changing the settings for frm and ctrl. I did however change a few things because I couldn't get the list box to display how I wanted which might be causing this. I instead put 2 combo boxes on the switchboard cmbFilter1 (for [Reprint Edition] and cmbFilter2 for [Reviewed Item]. I'm attaching my database to this mail in case you can help. Sorry if this is simple and a bother, but I don't understand how else to fix it.

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Hi mvasilevsky, I would prefer the combo boxes because they don't take up as much space on the switchboard. I thought with a listbox I could get it so that (in the same box) you could select the variables from multiple fields (for example GET and then INC from [Reprint Edition] and [Reviewed item] respectively). Instead, I think the best way to go about this might be 2 combo boxes. One thing I noticed was that with the list box method you showed, if I select one filter and then change to another it doesn't seem to change the sql query's filter to the second selection. Do you think the best way around this would be to make a 'remove filter' button? Also if you could show me how to edit the code to make it work with a combo box rather than list I would appreciate it.
Thanks so much, Bevo

Featured Post

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

The first two articles in this short series — Using a Criteria Form to Filter Records (http://www.experts-exchange.com/A_6069.html) and Building a Custom Filter (http://www.experts-exchange.com/A_6070.html) — discuss in some detail how a form can be…

In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page.
The problem with sub-reports and headings:
Add a dummy group to the sub report using the expression =1:
Set the “Repeat Section” property of the dummy…