MultiSelect List Boxes - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

MultiSelect List Boxes

Cindy Friend

4 years ago

I would like to open a form based on a cascading combo box that leads to a list box which I have made multiselect.

I have a form that calls requests - which are categorized by Service and Subservice.  Each Service has several Subservices and are used mostly as cascading combo boxes.

I want to be able to open a form based on a query that is based on drop down lists of Service and SubService.  I can do that if I want the form to only open for one particular SubService.

I would like to be able to open the form based on the list of Subservices in which users can choose one or more options.  I just finished Access Developer Lesson 15 and have done a lot of additional research but I am unable to make it work.

	Cindy Friend OP @Reply 4 years ago

	Cindy Friend OP @Reply 4 years ago

	Cindy Friend OP @Reply 4 years ago

Richard Rost @Reply

4 years ago

Keep going. There's a LOT more to learn about multi-select list boxes than what's covered in D15. D16 and D17 also cover them. You're probably going to need to write a custom SQL statement for the form's recordsource based on the values in the listbox which is going to require a recordset loop. That's covered in D16. Let me know when you've finished D17 and I'll help you more. Without a solid understanding of recordsets and the rest of the listbox material, I'll be speaking Greek to you.

	Cindy Friend OP @Reply 4 years ago
Thanks Richard. I wrote the code to do the loop and even got the code to generate the correct list of items. I put it into a new unbound box (which I will eventually hide) so I see that my code is calling the correct data. But when I put that data back into the query - it will not call out the correct records.

	Cindy Friend OP @Reply 4 years ago

	Cindy Friend OP @Reply 4 years ago

	Cindy Friend OP @Reply 4 years ago

	Cindy Friend OP @Reply 4 years ago
Just as a follow up... I tried to call the data into the query in two different ways. I called it with an IN function and with just pulling the data straight from the field in the form. I will download lessons 16 & 17 if you think they will be helpful.

	Richard Rost @Reply 4 years ago
Yeah, IN doesn't really work that way. You'll need to loop through your selected items and build a custom Where clause string.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View