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.