Populating a listbox from another multiselect listbox AfterUpdate event

[echecket]

I'm new here, so I apologize if I'm asking a question that's been asked a million times or violating forum norms. Here's my question:

I currently have 2 listboxes, listA and listB. listB has a query as a rowsource, filtered based off the value of the record selected in listA. That works great and all, but I need to set both listboxes as 'extended multiselect'. For the sake of easy explanation, lets say that listA provides a list of states, and listB provides a list of cities. I want the user to have the option of selecting 'Arizona', 'Nevada', and 'New York' in listA, for example, and have listB show all the cities that correspond to those states.

I saw other threads that deal with multiselect, but they didn't really seem to address what I'm trying to accomplish. Where do I go from here?

[pbaldy]

I'd combine the second method here:

http://www.baldyweb.com/CascadingCombo.htm

with the looping code to build an In() clause here:

http://www.baldyweb.com/multiselect.htm

[echecket]

Thanks, pbaldy! I'm working on your advice right now, but struggling to understand how the two should go together. In the meantime, if you have any suggestion for merging the two, I'd be very grateful.

[pbaldy]

Sorry, busy weekend. Did you get it sorted out? If not, what do you have so far?

[echecket]

Hey there,

Sorry I didn't respond. I have been out of the office since the last time I posted. I haven't really been able to figure it out yet. Still tinkering . . .