Cascading Combo / List Boxes

[plowe]

I have a form (Parts), which has ComboBox > List Box (Multi Value) > List Box (Multi Value)



I can populate List Box 1 with values based on a single selection in ComboBox, I then make multiple selections in List Box 1.

My aim is to then populate List Box 2 with with values based on the mulitple selections in List Box 1. (This is where i am stuck)


Example Data:

Combo Box (Make1) Row Source = SELECT DISTINCT Vehicles.Make FROM Vehicles;

Code:

Private Sub Make1_AfterUpdate()
Me.Models1.Requery

End Sub

List Box (Models1) Row Source = SELECT DISTINCT Vehicles.Model FROM Vehicles WHERE (((Vehicles.Make)=forms!Parts!Make1));

Code:

Private Sub Models1_AfterUpdate()
Me.Engine1.Requery
End Sub

List Box (Engine1) Row Source = SELECT DISTINCT Vehicles.Engine FROM Vehicles WHERE (((Vehicles.Model)=forms!Parts!Models1));


Please could someone shed some light on why the last list box wont display anything.

The table (Vehicles) has all the fields i need.

[pbaldy]

Code looks okay offhand. Make sure the column widths property isn't hiding the first column, since you only return 1.

[Missinglinq]

List Box (Engine1) Row Source = SELECT DISTINCT Vehicles.Engine FROM Vehicles WHERE (((Vehicles.Model)=forms!Parts!Models1));

I think the problem is with the line

Vehicles.Model)=forms!Parts!Models1

What you're saying, here, in plain language, is Select Engines where the Model is Equal to the Value of the Listbox named Models1.

The problem with this is that the Listbox is Multi-Select, and with the MultiSelect Property set to anything except None, it no longer has a Value Property!

To find the selections from a Multi-Select Listbox, you have to loop through it to find the selections. Here's an excellent example, by pbaldy, of Post #2, on how to do that:

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

Linq ;0)>

[pbaldy]

Brain cramp! I missed that the control was multi-select. .

[Missinglinq]

I've tried to find a use for Multi-Select since it sprang out of the collective minds of the Boys of Redmond, with no luck, to date , so I always look carefully at posts that mentions it! I pulled the link to your example, from my archive, before I realized that you were the one who had already responded!

Linq ;0)>

[pbaldy]

It's a handy tool; I've used it in a number of applications. Several times it's when users what to be able to specify one or more things to report on, like cars, shifts, etc. Today they may want to see cars 1,3,5 & 7 on the report, tomorrow they may want to compare 2,4 & 6. I've got an accounts receivable application where the user is presented with a list of yesterday's runs, and they select the item(s) applicable to the driver they're working on, which are then added to his data.