need help using form to select categories for report

[dlp111]

Hi,

It's been many years since I've done any access work. I'm trying to create a contacts database to print out labels. I want to use a form to select a specific category or multiple categories to print labels for. I've followed and tried adapting a similar database and code with no luck. Been fighting with it for a few days... I'm trying to use a multi-select list box on a form for the category selection. I need help getting the selections into the report or a query. I've attached the DB.

TIA,
Dan

[June7]

If you want to be able to select multiple items from listbox as filter criteria, need VBA code. Check this tutorial http://allenbrowne.com/ser-50.html

[dlp111]

I am getting an error after adapting this code. Not sure how to deal with it.

Error 3831 - The Multi-valued field '[Category]' cannot be used in a WHERE or HAVING clause.

Problem Solved, it seems to be working now after a google search on the error which brought me to this.

http://www.utteraccess.com/forum/VBA...-t1944811.html

[June7]

Multi-value fields, ugh! I REFUSE to use them.